Possible vlookup?


I’m trying to work a formula that will check if a value in one column on sheet one matches a value in another column on sheet two and if so, I need it to display the value in another column on sheet 2. Is that possible?

Sheet 1 = list

Sheet 2 = data

If Sheet 1 column 1 (amount) = sheet 2 column 2 (amount), display sheet 2 column 3 (reference) of the matching row.

hope this makes sense?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!