| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I run Excel LookUp on a single cell through multiple sheets
You can do it by combining a series of IFs, such as:
IF not present in Sheet1 table THEN IF not present in Sheet2 table THEN IF not present in Sheet3 table THEN "not present" ELSE return Sheet3 value ELSE return Sheet2 value ELSE return Sheet1 value Obviously, this is not an Excel formula, but hopefully you can see how to construct a lookup to 3 different sheets. Hope this helps. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I Auto-Filter with multiple values in a cell in Excel? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Can multiple cell results be displayed in a single cell? | Excel Discussion (Misc queries) | |||
| Multiple reference for lookup in excel | Excel Worksheet Functions | |||
Threaded Mode
