Get the "other" Value

Thomas Feith
edited 12/09/19 in Smartsheet Basics

Hi everyone,

I can't figure out a way to get me the value that I want with the Vlookup function.

I'm trying to check for the same value in a column (ID) and get back a value from a neighboring column (Gen). 

ID       Gen           Check

1           A

2           A

3           A

1           B

2           C

4           A

My Formula has been =VLOOKUP(ID@Row; ID:Gen; 2; false)

Everytime vlookup gives me the Value A, and I can't find a way to have a specification that it shouldn't be the same row.

Can somebody help please?


Thank You