Excel: Using Match & Index to replace Vlookup

I have seen comments that the match & index functions in Excel are more reliable than vlookup. Why is this? I would appreciate some guidance in using these functions in a practical example. I looked in the Help function and ended up baffled!
I use vlookup to identify cost centres for charging vehicle costs. The data about cost centres is in D7:J16 and the vehicle codes are in,say, B21:B30. So my formula in c21 =VLOOKUP(B21,$D$7:$J$16,5,FALSE). How would I use match and Index to replace this formula?

Thanks for your help.

Paul
Paul Olson

Comments
There are 6 comments. Login or register to view them.

Clarification

ryankirgan |
ryankirgan's picture

You might like to look at this more in depth article on the subj

ryankirgan |
ryankirgan's picture

Mmm...

neileg |

Dyed in the wool

neileg |

Thanks for the explanation.

AnonymousUser |

Just my hobby horse!

AnonymousUser |