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

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 isblank and iferror formula in one c

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 &am

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

Hi All, I want to put isblank and iferror formula in one cell. Can you please help. Attached sheet for your reference. Regards, Vijayendra 94491 67631 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urge