Thanks!!, now, will this also work, say if i had 4 sheets?
"Dave Peterson" wrote in message
...
Just do it twice:
=IF(NOT(ISERROR(VLOOKUP(A1,Sheet2!A:B,2,FALSE))),
VLOOKUP(A1,Sheet2!A:B,2,FALSE),
VLOOKUP(A1,Sheet3!A:B,2,FALSE))
(all one cell)
James wrote:
I have to do a vlookup, but the Table_array data is spread over two
worksheets because of the amount of data. Is this possible?
--
Dave Peterson
|