Using Vlookup to two different cell references
I may be overthinking this but I'm trying to get my formula to look at the cell below if the results come back with "NA". Is this possible?
In this case, if B2 comes back as "NA", then I want the formula to point to B3 instead.
IF(ISNA(VLOOKUP($B$2,MPS!$D$6:$AF$2492,2,TRUE)),(VLOOKUP($B$3,MPS!$D$6:$AF$2492,2,0)))
Have you tried your formula, and if it didnt what, what did you get? It looks like it should work. You can shorten it a bit by this...
IFERROR(VLOOKUP($B$2,MPS!$D$6:$AF$2492,2,TRUE),VLOOKUP($B$3,MPS!$D$6:$AF$2492,2,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The correct way of doing this is what is suggested by Ford.
But your formula didn't work because you didn't provide the false condition in the IF statement. Your formula should be like this....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks