vlookup for 4 different ranges
 

hi

is there any vlookup for 4 different ranges.

pls help.

regards

anil

vlookup for 4 different ranges
 

"hitesh" wrote in message
...
hi

is there any vlookup for 4 different ranges.

pls help.

regards

anil

You could write a complicated formula with nested IF statements such that it
looked in the first range, and if it found no match it looked in the second,
etc. However, a much simpler way would be to use simple link formulas in a
free area of a worksheet (=A1, =B1, or whatever) to get all the lookup data
into a single contiguous range, such that you could use a normal VLOOKUP
formula.