Possible vlookup?

IntriguedConfusion

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?

eLIZo

Move column 2 in sheet 2 to column 1, then you can use the formula below:

=VLOOKUP([Sheet1Column1]@row, {Column 1 to 3 Range from Sheet 2}, 3, false)

IntriguedConfusion

https://community.smartsheet.com/discussion/comment/367225#Comment_367225

Thanks, it’s giving me a formula parse error?

Julio S.

Hi @eLIZo,

Here's an example of a working VLOOKUP formula that you may use for your reference:

Formula and results:

Vlookup table used in cross-sheet reference:

I hope that this can be of help.

Cheers!

Julio