| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inverse Table Lookup
Excel Lookup functions normally return a Table value based on a row,column
search criteria. I need to return the row, column based on the table value. Any ideas Appreciated, Thanks in Advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inverse Table Lookup
LOOKUP?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dave White" wrote in message ... Excel Lookup functions normally return a Table value based on a row,column search criteria. I need to return the row, column based on the table value. Any ideas Appreciated, Thanks in Advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inverse Table Lookup
No. Respectfully, I do not think you understand what I need.
I need a function that returns the ROW, COL position (better word) of a TABLE value. LOOKUP gives me the TABLE value of a ROW, COL position. "Bernard Liengme" wrote: LOOKUP? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dave White" wrote in message ... Excel Lookup functions normally return a Table value based on a row,column search criteria. I need to return the row, column based on the table value. Any ideas Appreciated, Thanks in Advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inverse Table Lookup
If your Table is a named array of unique numbers and letters
and your named column and row headers are numbers then find the column/row of a certain LookupValue with =SUMPRODUCT((Table=LookupValue)*(ColumnHeader)) =SUMPRODUCT((Table=LookupValue)*(RowHeader)) If LookupValue is text, add " ", like "LookupText" If the column/row headers are letters or names, add numbered headers and use LOOKUP to translate. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inverse Table Lookup
Have a look at MATCH and then at INDEX
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dave White" wrote in message ... No. Respectfully, I do not think you understand what I need. I need a function that returns the ROW, COL position (better word) of a TABLE value. LOOKUP gives me the TABLE value of a ROW, COL position. "Bernard Liengme" wrote: LOOKUP? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dave White" wrote in message ... Excel Lookup functions normally return a Table value based on a row,column search criteria. I need to return the row, column based on the table value. Any ideas Appreciated, Thanks in Advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| What formula can I set up to do a cross lookup in an Excel table? | Excel Worksheet Functions | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Hybrid Mode
