| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use HLOOKUP for different sheets depending on results from 2 cells
I have 2 cells with 3 possiable results each. Depending on the results
from both these cells, determines which sheet needs to be used to lookup the correct data on. I can get it to work when I specify what sheet to use, but the sheet is a variable and I cannot figure out how to get it to work. Thank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
| formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
| How to populate sheets from a specified set of cells.. | Excel Worksheet Functions | |||
| How do I protect formula cells on multiple sheets? | Excel Worksheet Functions | |||
| How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
Threaded Mode
