VLOOKUP With Same Values

Selects

New Member
Joined
May 29, 2012
Messages
3
UPokB.jpg


As you can see, I'm attempting to show differences between these companies based on these particular values. The problem is many of the companies have the same values, and VLOOKUP just repeats the company with the first value it finds. I'm trying to figure out how to have VLOOKUP realize that there are other companies with the same value, so each company is accounted for.

Thanks,
Selects
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Welcome to MrExcel!

I'm not clear what you're trying to do here. Could explain further?

It also doesn't help much when pictures are posted, as we can't copy the data out to test possible solutions in Excel. Try the Excel Jeanie for posting data in future:

http://www.excel-jeanie-html.de/index.php?f=1

Matty
 
Upvote 0
Thanks for the warm welcome!

I'm at work and need admin access to install programs, so unfortunately I can't install the excel genie until I can get someone in IT up here.

What I am doing is ranking these companies from from least to greatest based on the value in column D. I used the SMALL formula to put the numbers in order from least to greatest in column B (lines 17-26), then used VLOOKUP to relate those numbers back to the company.

This image should help more:

vFjE0.jpg


So the code for A17:A26 looks like this: =VLOOKUP(G23,$E$9:$F$20,2,FALSE)

The values for column "E" are the same as column "I", it's just more convenient to have them next to the companies code-wise.

The problem is that when VLOOKUP pulls the information from column "E", it can't differentiate between the first instance of "0" versus the second instance of "0", and the same goes for the other duplicate amounts. Instead, it always chooses the first value and the corresponding company. So, when the table below should read:
Titan of Louisiana Inc. 0

as the first line, the next line should read:

Renovate, Inc. 0

but, it continues to reference Titan instead.

So, I need to find a way to have each company accounted for, even if the values are the same.

I hope this isn't too confusing.

- Selects
 
Upvote 0

Forum statistics

Threads
1,211,868
Messages
6,104,458
Members
447,910
Latest member
abrook1308

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top