Pull in data from Master File

System

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

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!

Brad

Genevieve P.

Hi @bentlb3

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

https://community.smartsheet.com/discussion/comment/327345#Comment_327345

Cheers,

Genevieve