There’s a new Excel spreadsheet formula which may well take the place of VLOOKUP for you! It’s called XLOOKUP and it’s available if you have an Office 365 account.
Watch my short ‘How to’ video to find out how to use it and why it is more flexible. Unlike VLOOKUP you do not need to say which column you want to return data from and the default is exact match. But best of all, you can delete or insert columns without breaking your formula.