vlookup question (sheet to sheet)

Jillian M
Jillian M ✭✭
edited 10/04/23 in Formulas and Functions

I think I need a VLookup formula but I'm stumped. I have 2 sheets where each row of data has an individual row number in a column--the data in each row is exactly the same. I need a formula on the secondary sheet to check the row number on the master sheet. If the row number on the secondary sheet matches the row number on the master sheet, then it places a "yes" in the cell on the secondary sheet. (We are trying to be able to filter out rows that are deleted on the master sheet). I hope this makes sense...



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!