Welcome!

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

Find more posts tagged with

Comments

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.

Sign in to join the conversation!

Trending discussions

Is there an issue with using reports on a dashboard to create a graph?
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
Selected Data Cannot be charted
It does not matter which data I select, I am getting the error of Selected data cannot be charted. I even tried reusing a report that is producing a chart on a different dashboard, but I am unable to create new charts in a dashboard. Anyone have any ideas as to why?
Upgrade user mismatch
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.