Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick from table based on row and column header
whats the best way to pick single values from a table based on text column
and row headers, i.e: ABC D 2 E F B:D=2 it has to be done using headers as new columns may be added thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick from table based on row and column header
Hi
=INDEX($1:$65536,MATCH("D",$A:$A,0),MATCH("B",$1:$ 1,0)) That would deal with the whole of a sheet (in XL2003) and assumes that your letters D, E, F etc are in Column A, and your A, B, C etc are in Row 1 Adjust accordingly -- Regards Roger Govier "PBcorn" wrote in message ... whats the best way to pick single values from a table based on text column and row headers, i.e: ABC D 2 E F B:D=2 it has to be done using headers as new columns may be added thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pick from table based on row and column header
One way:
=VLOOKUP("D",A1:D4,MATCH("B",A1:D1,0),0) Or, use cells to hold the criteria: A10 = D B10 = B =VLOOKUP(A10,A1:D4,MATCH(B10,A1:D1,0),0) -- Biff Microsoft Excel MVP "PBcorn" wrote in message ... whats the best way to pick single values from a table based on text column and row headers, i.e: ABC D 2 E F B:D=2 it has to be done using headers as new columns may be added thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data from other worksheet based on column header | Excel Discussion (Misc queries) | |||
Pivot table header column included in calculation | Excel Discussion (Misc queries) | |||
Select max value in a row and pick the column header | Excel Discussion (Misc queries) | |||
Sorting data in a table by the header of a column? | Excel Discussion (Misc queries) | |||
Stripping time in Pivot Table Column Header | Excel Worksheet Functions |