That did the trick. One last problem: I want to search for a number
from a range of numbers in column 1 (or columns 1 and 2 of the data to
be retrieved and return the corresponding data in columns 2 and 3 (or 3
and 4).

How should the data to be retrieved be arranged on sheet 2? Should the
range (0 - 20,000) be in a single cell/column (column 1) or in separate
columns (0 in column 1 and 20,000 in column 2)? How then would the
vlookup formula be input on sheet 1? As before, the returned data will
be used in a mathematical formula from another cell.

Thank you.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!