pick from table based on row and column header

[PBcorn]

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=2

it has to be done using headers as new columns may be added

thanks

 

[Roger Govier]

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

 

[T. Valko]

One way:

=VLOOKUP("D",A14,MATCH("B",A11,0),0)

Or, use cells to hold the criteria:

A10 = D
B10 = B

=VLOOKUP(A10,A14,MATCH(B10,A11,0),0)