v lookup multilple columns
I'm confused!
I have performed a vlookup of column d in spreadsheet 2.
When I get the error value as a return
OK, why are you getting an error?
It could be due to 1 of 2 reasons.
1. the lookup value, C65, does not exist in the lookup table
2. the lookup value, C65, does exist but there is an error in the
corresponding cell in column X
If the lookup value does not exist then you'll still get an error no matter
what column index number you use in the formula.
--
Biff
Microsoft Excel MVP
"dhermus" wrote in message
...
On Oct 7, 1:58 pm, dhermus wrote:
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?
I am using this formula to retrieve the data from column d. Because
the data is not sorted in column e, I have not been successful. The
errors in column e should be minimal, if any.
=VLOOKUP(C65,'[Consolidated Fin Plans -Oct6-1.xls]detail'!
$1:$65536,4,FALSE)
|