Matching Values

[clumpa]

I have effectively a 4 column spreadsheet

Col A D A E B C

Col C A B C D E which is fixed

Col D 4 3 0 1 5

I want to populate col B with the matching value from col D
i.e. col B should read 1 4 5 3 0

I have tried a combination of INDEX MATCH & OFFSET but got into a real muddle!!

Any help would be really appreciated

 

[shrivallabha]

You can use VLOOKUP.

=VLOOKUP(A1,$C$1:$D$5,2,0)

And INDEX,MATCH can be used like:

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

 

[clumpa]

You can use VLOOKUP.

=VLOOKUP(A1,$C$1:$D$5,2,0)

And INDEX,MATCH can be used like:

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

Thanks, just what I wanted/needed!!