VLOOKUP - cross referencing two data sources

April007

Hi All,

Beginner user here :)

I would like to cross reference a member number on a sheet that is generated by a form to a master list on another sheet to see if that member has submitted the form. This will allow me to check who has not sent in a form so I can send a reminder email.

I'm thinking using the VLOOKUP formula but can't seem to get it to work?

Thanks in advance!

KPH

Hi @April007

VLOOKUP or INDEX and MATCH should do what you want.

There is a guide to using INDEX and MATCH here: https://community.smartsheet.com/discussion/84774/index-and-match-across-two-sheets-a-detailed-explanation/p1

If you can't get it to work, share what you have done - screenshots of the two sheets, and the formula you are using - and someone will be able to troubleshoot it for you.

KPH

Hi @April007

VLOOKUP or INDEX and MATCH should do what you want.

There is a guide to using INDEX and MATCH here: https://community.smartsheet.com/discussion/84774/index-and-match-across-two-sheets-a-detailed-explanation/p1

If you can't get it to work, share what you have done - screenshots of the two sheets, and the formula you are using - and someone will be able to troubleshoot it for you.

April007

Perfect - that was a great help - much better option to go with INDEX and MATCH :)

Thanks for your help!

KPH

Great. Thanks for letting me know.