Hello all. I think this should be fairly easy but I'm not having any luck. I've attached an example file to help show what I'm trying to do. I need to look thru a list of brands and if it finds the brand give the results I need. I can make this work. The problem is when the brand is not listed I get #N/A. I need it result in a blank cell or 0.
Thanks in advance.
For Excel 2003 and lower, =IF(ISNA(VLOOKUP(F6,A6:C13,2,0)),"",VLOOKUP(F6,A6:C13,2,0))
For Excel 2007 and higher, =IFERROR(VLOOKUP(F6,A6:C13,2,0),"")
In both cases, you can change the "" to a 0.
In your case you would do like this:
Formula:
Please Login or Register to view this content.
But I would suggest doing this:
Formula:Please Login or Register to view this content.
And put it in G3 and copy down and across; in that case you only need one formula instead of two.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Tryand copy down.
Please Login or Register to view this content.
Thanks all. You make this look so easy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks