Re: $$Excel-Macros$$ Help on isblank & iferror

Glad to help Don Guillett SalesAid Software dguille...@gmail.com From: Vijayendra Rao Sent: Sunday, December 18, 2011 11:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on isblank & iferror Thanks Don Guillett and Aamir Shahzad for your support. The solutions

Re: $$Excel-Macros$$ Help on isblank & iferror

Thanks Don Guillett and Aamir Shahzad for your support. The solutions was very good and very quick. Regards, Vijayendra 2011/12/18 dguillett1 > =IF(A3="","",IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),"not recieved")) > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Vijayend

Re: $$Excel-Macros$$ Help on isblank & iferror

Dear Vijay, Please find solution with Isblank+Iferror Combination.. =IF(*ISBLANK(A2)*=TRUE,"",*IFERROR*(VLOOKUP(A2,Sheet1!$A:$A,1,0),"not recieved")) - Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.co

Re: $$Excel-Macros$$ Help on isblank & iferror

as desired =IF(ISBLANK(A2),"",IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$A$3,1,0)),"Not Received",SUMIF(Sheet1!$A$2:$A$3,A2,Sheet1!$B$2:$B$3))) See the attached sheet. Aamir Shahzad On Fri, Dec 16, 2011 at 5:44 PM, Vijayendra Rao wrote: > Hi All, > > I want to put isblank and iferror formula in one cell.

Re: $$Excel-Macros$$ Help on isblank & iferror

=IF(A3="","",IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),"not recieved")) Don Guillett SalesAid Software dguille...@gmail.com From: Vijayendra Rao Sent: Friday, December 16, 2011 6:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on isblank & iferror Hi All, I want to put isbla