| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need an Excell function that can lookup vertical AND horizontal
I need a function or combination of functions that can first search say
vertical in the leftmost column and then horizontal on the top line and then read a value in the table. It must thereforehave two input criterion. In the example below it must first look up "Bruce" as input criteria 1, then look up "Good" as input criteria 2 and then return "6" as the output. Excellent Good Bad Very Bad John 8 5 3 1 Peter 10 8 4 2 Bruce 7 6 2 1 Eric 9 8 6 3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vertical to Horizontal | Excel Discussion (Misc queries) | |||
| Need lookup of data both vertical and horizontal | Excel Discussion (Misc queries) | |||
| Excell page moves horizontal not vertical | Excel Discussion (Misc queries) | |||
| Vertical to horizontal | Excel Discussion (Misc queries) | |||
| How do I get both horizontal and vertical frozen panes in Excell | Excel Discussion (Misc queries) | |||
Threaded Mode
