| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse Lookup column only
How do i do a reverse lookup to show the heading in the first row. Example:
Say I want to now which month the value 29 show up in the below table? All I want the answer is "MAR" or value of 32 is in "Apr". Many thanks 1 A B C D 2 Jan Feb Mar Apr 3 25 27 29 31 4 26 28 30 32 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse Matrix lookup? | Excel Discussion (Misc queries) | |||
| Reverse lookup | Excel Worksheet Functions | |||
| reverse mapping for LOOKUP table? | Excel Worksheet Functions | |||
| How to reverse the column name and row name? | Excel Discussion (Misc queries) | |||
| Need help with reverse phone lookup | Excel Worksheet Functions | |||
Threaded Mode
