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.
- Retrospective VAT Query 89 2
- property capital gains 386 4
- AMAP on borrowed car?? 153 6
- VAT joint margin scheme arrangement 64 1
- Chargeable Event - life insurance bond written in trust 110 2
- FHLs and Entrepreneurs Relief 272 8
- Client gets a penalty and being threatening! 837 9
- Tips on meals 550 5
- Private doctors - Ltd company vs partnership 1,325 15
- S.455 Tax again 442 9
- Overdrawn directors loans and insolvent winding up 166 3
- Closing down loss-making company 791 15
- Stumped - IHT 607 8
- Can any cloud accounting package cope with operating a Foreign Branch and UK Head Office? 149 1
- Overpaid In Employers NI - RTI EYU for hundreds of employees 496 3
- Entrepreneur relief and deduction of Amortisation of Goodwill Pre2002 405 14
- co-operatives & Societies 125 1
- HMRC having technical difficulties 1,233 20
- Xerocon 2016 1,486 40
- Website Content 478 6