Get the "other" Value

Thomas Feith

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

 

Paul Newcome

The problem is that you have 2 entries for ID 1. You have an A and a B. The VLOOKUP formula you are using is going to only display one result, and that will be the first result it encounters.

 

If you are able to provide more details as to exactly what you are trying to accomplish, we may be able to help you with a solution.

Jacques@SBP

I have recently tried using vlookup and got very unpredictable results.  For certain values it matches well and returns the value, for other values in the list that are clearly there, it returns no match. 

 

As a result, I have do not trust this formula anymore and have switched to Index-Match formula combination which works perfectly.  

Paul Newcome

I prefer INDEX/MATCH over VLOOKUP as well, but even that won't provide the solution the poster is looking for for because there are multiple entries for the same ID number.