Extracting information from table

[Guest]

Hi
I have a table as follows
blue green yellow
4 jane heidi natalie
3 bruce sharon fred
2 sally paul Ken
1 brendon kevin graham

(excuse the layout but you'll get the idea). I want to put a formula in
another worksheet than includes blue and 2 (being the column and row headers)
and get 'Salley" returned being the contents of the cell at the intersection
of the named column and row.

Can someone point me in the right direction - I've tried DGet and Index but
they don't work as I need them to (unless I'm missing something"

Thanks

IanB

 

[Guest]

This is exactly what INDEX does:

=INDEX(B25,match(2,$A$2:$A$5,0),"Blue",$B$1:$D$1,0))

Assuming your table including headers is in A15

HTH

 

[T. Valko]

With you table in the range A15

B11 = column headers
A2:A5 = row headers

A10 = lookup value = blue
A11 = lookup values = 2

=VLOOKUP(A11,A15,MATCH(A10,A11,0),0)

result = sally

Biff