PDA

View Full Version : Lookup Formula



excel_learner
02-01-2012, 01:38 PM
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 Fox
02-01-2012, 03:08 PM
=IFERROR(VLOOKUP(G5,$B$5:$C$13,2,0),"XXXX")