| 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 & TWO DIFFERENT RANGES | New Users to Excel | |||
| vlookup - choice of ranges | Excel Discussion (Misc queries) | |||
| VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
| vlookup ranges | Links and Linking in Excel | |||
| vlookup and named ranges | Excel Worksheet Functions | |||
Threaded Mode
