Possible vlookup?

Options

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!