What should happen if the lookup against column E results in an error?

How about posting the formula you are using?

--
Biff
Microsoft Excel MVP


"dhermus" wrote in message
...
I have performed a vlookup of column d in spreadsheet 2. When I get
the error value as a return, I want to then perform the same lookup
against column e in spreadsheet 2. Soreadsheet 2 is sorted by column
d, then column e. This data will be updated and the worksheets
refreshed. Can anyone help?