I'm trying to write a vlookup that will look at an array of 3 columns.... the vlookup returns the second column but if there is an NA in the second column then it moves to take the value in the thirs column. Is this possible? I have attached an excel as an example. thanks
Assuming that you have a true #N/A error in your second column (i.e. resulting from a formula) then in B3 dragged down
=IF(ISERROR(VLOOKUP(A3,$G$2:$I$8,2,FALSE)),VLOOKUP(A3,$G$2:$I$8,3,FALSE),VLOOKUP(A3,$G$2:$I$8,2,FALSE))
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks you. I would also need to be able to do this if it contained the text NA. Is that possible
ChemistB is offline so I'll try to adjust what he gave you:
=IF(OR(ISNA(VLOOKUP(A3,$G$2:$I$8,2,0)),VLOOKUP(A3,$G$2:$I$8,2,0)="NA"),VLOOKUP(A3,$G$2:$I$8,3,0),VLOOKUP(A3,$G$2:$I$8,2,0))
If it works for you make sure to click on ChemistB's scales to thank him.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks