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

Z

Ziv

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
 
B

Biff

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
 
N

Niek Otten

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top