LinkBack URL
About LinkBacks
I have dropdown list in A7, and VLOOKUP in C7, if A7 is blank then I need C7 is also blank, which formula I am using giving error " N/A "
=VLOOKUP($A$7,table,2,FALSE)
Any help, Thank you
I have dropdown list in A7, and VLOOKUP in C7, if A7 is blank then I need C7 is also blank, which formula I am using giving error " N/A "
=VLOOKUP($A$7,table,2,FALSE)
Any help, Thank you
Hi,
Try this,
=IF(A7="","",VLOOKUP($A$7,table,2,FALSE))
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thank you OldChippy
It is work but when I select value in list then I got #NAME? error
Hi,
=IF(A7="","",VLOOKUP($A$7,table,2,FALSE)) have you NAMED the table area?
If not select the cells the make the table for example G1:H10, click in the "Name Box" to the left of the formula bar and type table
More on VLOOKUP here http://www.contextures.com/xlFunctions02.html
Last edited by oldchippy; 05-24-2008 at 05:46 AM.
Thank you I got it. Thank you for help.
Glad to help - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks