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.
- flat rate scheme 832 28
- Unqualified accountants filing SATR, VAT returns etc for clients 598 18
- TAX CERTIFICATES- DO THEY NEED TAXPAYER'S NAME? 126 1
- Accountants reference for me?? 247 1
- CIS online 162 3
- Class IV NIC 186 3
- bookkeeping system 211 4
- Company van paid by director 119 1
- Are you going to Tick and Bash on 21 May? 1,574 46
- Deferred income - financial concern no recognised turnover CT600 254 3
- changes to small vat returns after death. 141 3
- Private company division 119 1
- Office 365 vs. Google apps 309 6
- Are any of you members of The Institute of Financial Accountants - Accountnats certificate 644 7
- Split year treatment ? 130 1
- How to reward a long standing employee 286 3
- PPR relief - deemed residence? 114 2
- New intermediaries reporting requirements 210 2
- Windows 7 to 8 should I go Excel or Office 365 260 3
- Special dividends & CGT 314 2