| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and logical functions
Hi
I'm trying to do a VLOOKUP from two different sheets on a another workbook. Can a person combine say for instance a logical function like OR together with VLOOKUP? E.g. =OR(VLOOKUP(lookup_value,'[Register.xls]A3'!table_array,col_index_num,FALSE,VLOOKUP(lookup _value,'[Register.xls]K'!table_array,col_index_num,FALSE)) I've tried this, but it doesn't seem to work. I'm not sure what other functions one could try to achieve this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Using Vlookup as "value_if_true" in IF function | Excel Worksheet Functions | |||
| Get Vlookup to look at multiple Rows for the answer | Excel Worksheet Functions | |||
| Vlookup but also equal to and greater than? | Excel Worksheet Functions | |||
| work-around for "vlookup: with unsorted data | Excel Worksheet Functions | |||
Threaded Mode
