Excel version 2108 - vlookup problem

Question

there seems to be a problem with the update version of 2108 in that vlookups are not working how they used to be, in that if you delete or insert a column in the source data the vlookup NO LONGER automatically recognises this i.e.

= vlookup(a2,rangename,3,0) if you inserted a new column in B of rangename, the vlookup used to recognise this and change the column from 3 to 4. It is no longer doing this and is dangerous to our M.I. reporting

Answer 1

Hi, @Anonymous
Maybe you can try using the XLOOKUP function or the INDEX/MATCH function.
If you still want to use the original VLOOKUP function, you can roll back the Excel version.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.