| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup combined with Hlookup
I am trying to lookup data that is in a named range across columns and rows:
Rough idea as follows : Week1 Week 2 Week 3 ABC 20 30 40 DEF 10 20 30 I would like to be able to look for ABC in week2 , no matter in what column number on the spreadsheet it may appear. The column will allways have the heading Week2. Is there a way to combine the Vlookup and or Hlookup functions so that I can find ABC Week2 as long as it appears in the named range but without having to specify what column number it will be in ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HLookUp combined with a VLoopkUp... | Excel Worksheet Functions | |||
| combined HLOOKUP (urgent for a friend) | Excel Worksheet Functions | |||
| vlookup combined with AND-function | Excel Worksheet Functions | |||
| vlookup and match combined? | Excel Worksheet Functions | |||
| Combined VLOOKUP AND BETWEEN FUNCTION | Excel Worksheet Functions | |||
Threaded Mode
