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

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,A1:D4) and
return 4

Thnaks in Advance

Hi!

Try one of these:

=VLOOKUP(A7,A2:D4,MATCH(A6,A1:D1,0),0)

=INDEX(B2:D4,MATCH(A7,A2:A4,0),MATCH(A6,B1:D1,0))

Biff

-----Original Message-----
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,A1:D4) and
return 4

Thnaks in Advance

.

=VLOOKUP(A7,A2:D4,MATCH(A6,B1:D1,FALSE)+1,FALSE)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Ziv" wrote in message
...
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,A1:D4) and
return 4

Thnaks in Advance