Get the "other" Value
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
Comments
-
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.
-
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.
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives