Dear Venkat,
Please try.
=IF(VLOOKUP(I11,$B$3:$C$14,2,0)=0,,VLOOKUP(I11,$B$3:$C$14,2,0))
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Aug 8, 2011 at 11:37 AM, Venkat CV venkat1@gmail.com wrote:
Dear
Dear Noorain,
Thanks for your Try...
The Below Formula is working for Cell is Blank...
But If cell Value is 0 That's the case not working...
If Cell is 0 and also Coming Blank...It should Come has a 0
*Best Regards,*
*Venkat *
*Chennai*
On Mon, Aug 8, 2011 at 11:43 AM, NOORAIN ANSARI
IF(NOT(ISERROR(VLOOKUP(I3,$B$3:$C$14,2,0))),IF(VLOOKUP(I3,$B$3:$C$14,2,0)=,,VLOOKUP(I3,$B$3:$C$14,2,0)),Not
Found)
On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV venkat1@gmail.com wrote:
Dear Noorain,
Thanks for your Try...
The Below Formula is working for Cell is Blank...
But If cell
Dear Venkat try it
=IF(OR(VLOOKUP(F3,$B$3:$C$14,2,0)=0,VLOOKUP(F3,$B$3:$C$14,2,0)=),,VLOOKUP(F3,$B$3:$C$14,2,0))
On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV venkat1@gmail.com wrote:
Dear Noorain,
Thanks for your Try...
The Below Formula is working for Cell is Blank...
But If cell Value
Dear Ashish,
WorkingThank you
Dear Noorain,
Ashish's formula WorkingThanks for your try.
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Mon, Aug 8, 2011 at 12:33 PM, ashish koul koul.ash...@gmail.com wrote:
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Monday, August 08, 2011 11:37 AM
To: Google
Subject: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...
Dear All,
Find attached query regarding While