I am using lookup formula for values in range to get the desired value for a lookup value, however, lookup formula fetches the value if it falls in range and if the value is not in the lookup range i want to put else condition.
I have attached the file for easy reference.
Kind assist ASAP.
----
excel_learner
(Using XL 2007 & 2010)
-------Learning never stops!
=IFERROR(VLOOKUP(G5,$B$5:$C$13,2,0),"XXXX")
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks