Returning a Cell Value from the same Row as a Match

[gardenhead]

Hello,

Locating the match is easy enough but I'm not sure how to return the
cell next to it.

A B C D
1 pig duck quack
2 horse pig oink
3 cow horse neigh
4 duck cow moo

What I want is to search column C for the variables in column A - if
there's a match I want it to return the value in the D column from the
same row of the cell that matched. This would make B1 "oink", B2
"neigh", B3 "moo", etc. (need to be able to fill down).

Thanks in advance...

 

[Don Guillett]

Have a look at the INDEX function where you use your MATCH for the row.

 

[Biff]

Hi!

Try one of these:

=VLOOKUP(A1,C$1$4,2,0)

=INDEX(D$1$4,MATCH(A1,C$1:C$4,0))

Biff

 

[gardenhead]

Thanks guys, that was a real softball for ya