HOW DO I FIND DATA IN A TABLE BY LOOKING UP BOTH THE COLUMN AND R.

[Guest]

If I have a table for example
| A | B | C | D
--------------------------------
1 | | A | B | C
2 | X | 1 | 2 | 3
3 | Y | 4 | 5 | 6
4 | Z | 7 | 8 | 9
5 |
6 | A
7 | Y
Is there a function that does the following? =FUNCTION(A6,A7,A14) and
return 4

Thnaks in Advance

 

[Biff]

Hi!

Try one of these:

=VLOOKUP(A7,A24,MATCH(A6,A11,0),0)

=INDEX(B24,MATCH(A7,A2:A4,0),MATCH(A6,B11,0))

Biff

 

[Niek Otten]

=VLOOKUP(A7,A24,MATCH(A6,B11,FALSE)+1,FALSE)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel