# VLOOKUP With Same Values

#### Selects

##### New Member

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
Bump.

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

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:

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

Replies
2
Views
264
Replies
12
Views
715
Replies
6
Views
247
Replies
1
Views
279
Replies
1
Views
1K

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.

### Which adblocker are you using?

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

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