| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup value in table
Need to determine column of the lookup value in a table.
Lookup value = 6/1/06 Table A B C row 1 7/1/05 7/1/06 7/1/07 row 2 6/1/05 6/1/06 6/1/07 row 3 5/1/05 5/1/06 5/1/07 The answer should column 2. Your help is greatly appreciated. -- Bonita |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vLookup with multiple lookup value in table array | Excel Worksheet Functions | |||
| Inverse Table Lookup | Excel Worksheet Functions | |||
| formatting a cell the same as the source cell from a lookup table | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Threaded Mode
