| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP & TWO DIFFERENT RANGES
Hello All,
Can VLOOKUP lookup in two different different ranges residing in separate worksheettabs? In other words, if a match is not found in the first range then lookup the 2nd range. Can someone help in constructing such formula? Regards SJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP, changing ranges | Excel Discussion (Misc queries) | |||
| vlookup on non-contiguous ranges | Excel Worksheet Functions | |||
| multiple ranges on Vlookup | Excel Discussion (Misc queries) | |||
| vlookup ranges | Links and Linking in Excel | |||
| How do I do a VLOOKUP from 2 ranges and add the results together? | Excel Worksheet Functions | |||
Threaded Mode
