Forum Discussion
Solved
VLOOKUPS with new columns inserted
Can someone help me understand how to perform a VLOOKUP on new columns that are inserted into a table?
I want to insert new date columns in between BP and BQ, so when the vlookup is performed it pulls through the last three columns. When a new one is inserted, this will need to be considered as the latest three?
Thanks
- Hi Jan,
Thanks this works - but I will be adding columns after column R on sheet 2 continuously. Will this affect the date?
Also, I want the dates in columns D-I on sheet 1 to automatically pick up the last 3 date columns too.
9 Replies
- It works better if you post a sanitized version of your workbook with just the relevant pieces in it. I'd say you might better use something like the new XLOOKUP function, or a combination of INDEX and two MATCH functions.
- Hi Jan, would you able to provide an example formula please?
- Sure, if you provide a sample sheet 🙂
