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.