Pull in data from Master File

System Employee Admin
This discussion was created from comments split from: Pulling data from another sheet (vlookup?).


  • bentlb3
    bentlb3 ✭✭✭✭

    Similar to my request above, I need to adjust it a little to pull in data from a corresponding field. Here is my scenario:

    I have a master file in smartsheet that was imported from an excel file. A column of data was deleted and I need to get that data back in the smartsheet file from the main excel file.

    I can use your formula above but need to modify it, and that's where I'm stuck. I would like to:

    • look at column 1 in the smartsheet file and look for a match in column 1 of the excel file
    • if there is a match, then I would like to return the contents at that row in column 2 of the excel file and populate column 2 at the row with that data

    I'm sure I overcomplicated my explanation, but I hope that gives an understanding.

    Thank you for your help!


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @bentlb3

    It looks like Debbie has answered your question back on the original thread: