| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hlookup in other columns
In doing a hlookup I would like returned the cell contents from the left
column and also left of that as in the example x y z aa ab ac 1 2 3 4 5 6 hlookup(ab1,a1:dd1000, 1) = 5 but I am interested in receiving answer 4 and separetely answer 3 Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to see columns from which values were not returned by HLOOKUP functions? | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
