Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v lookup multilple columns
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v lookup multilple columns
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v lookup multilple columns
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lookup multilple criteria and return a single value | Excel Worksheet Functions | |||
Multilple linked Cells with Combo box | Excel Discussion (Misc queries) | |||
Help searching and summing across multilple worksheets | Excel Discussion (Misc queries) | |||
splitting data from 1 column into multilple? | Excel Worksheet Functions | |||
SUMING VARIOUS LINE ITEMS FROM MULTILPLE WORKBOOKS | Excel Worksheet Functions |