# Simple cross-reference formula

This is a discussion on Simple cross-reference formula within the Excel Questions forums, part of the Question Forums category; I'm trynig to retrieve the data from a cell that is next to a cell with a certain value. Here's ...

1. ## Simple cross-reference formula

I'm trynig to retrieve the data from a cell that is next to a cell with a certain value.

Apple 1
Boy 2
Cat 3
Dog 4

If cell a6 is 4, then I want cell a7 to display "Cat".
This is probably really simple, but I'm pretty new to excel and couldn't figure it out.

2. ## Re: Simple cross-reference formula

Assuming that your data is in A1:B4, try this formula in B6

=INDEX(A1:A4,MATCH(A6,B1:B4,0))

3. Hi - welcome to the board!

Review the help file for vlookup - post back if you need more.

4. ## Re: Simple cross-reference formula

Originally Posted by lennon74
I'm trynig to retrieve the data from a cell that is next to a cell with a certain value.

Apple 1
Boy 2
Cat 3
Dog 4

If cell a6 is 4, then I want cell a7 to display "Cat".
This is probably really simple, but I'm pretty new to excel and couldn't figure it out.
a7=if(a6=4,"cat","") etc

5. ## Re: Simple cross-reference formula

Actually, Paddy's wont work either, because this is (If I understood correctly) a left-hand lookup, which can be achieved using INDEX/MATCH.

6. ## Re: Simple cross-reference formula

Works perfect, thanks for all your quick responses!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•