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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
