hitesh said:
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.
