Forum Discussion

milo1234's avatar
milo1234
Brass Contributor
Mar 11, 2021
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 pu...
excel
Formulas and Functions
  • milo1234's avatar
    milo1234
    Mar 15, 2021
    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.
JKPieterse's avatar
JKPieterse
Silver Contributor
Mar 11, 2021
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.
milo1234's avatar
milo1234
Brass Contributor
Mar 11, 2021
Hi Jan, would you able to provide an example formula please?
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Mar 11, 2021
    Sure, if you provide a sample sheet 🙂
    • milo1234's avatar
      milo1234
      Brass Contributor
      Mar 14, 2021

      Thanks JKPieterse 
      So when I add a new column between column L and M on sheet 2, the table within sheet 1 automatically pulls the latest 3 columns highlighted yellow (columns D - I on sheet 1).

       

      Then when a column is inserted after column Q on sheet 2, the 3 latest columns are pulled through to the table within sheet 1 (columns J-L in sheet 1).

       

      Please find sample data attached.
      Thanks.

       

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Mar 15, 2021

        milo1234 I think you asked for the attached, but I'm not 100% sure. Please note that this assumes you are using Excel 365.

Resources