# VLOOKUP when there are duplicate values in table_array

#### dan_dan_noodles

##### New Member
I have looked at other threads dealing with similar issues and frankly couldn't figure out how to apply them to my situation. Please let me know if you can help.

Situation:
- I get daily volume data from our store locations
- I need to generate a report that ranks our stores in descending order by volume
- I need to use formulas for this (no manual sorting, pivot); the report needs to be automatically done when daily data is added to the data sheet

Problem:

- I use the LARGE function to rank the Volume, then use vlookup to find the Store # for that volume
- I don't know how to modify the vlookup function when 2 (or more) stores have the same volume. See example below.

Thanks.

==

Daily Volume Data

(A) (B) (C)
Volume Store # Store Name
\$202 101 Red Bluff
\$225 102 Porterville
\$202 103 Loveland
\$376 104 Mt Pleasant
\$53 105 Mt. Crawford

Rank by Volume

(A) (B) (C)
Ranking Volume Store #
1 \$376 104
2 \$225 102
3 \$202 101 (duplicate)
4 \$202 101 (duplicate)
5 \$53 105

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Hi.

Maybe like this ...?
Excel Workbook
ABCDEFGH
1VolumeStoreShop-NameRankingVolumeStoreShop-Name
2\$202101Red Bluff1\$376104Mt Pleasant
3\$225102Porterville2\$225102Porterville
4\$202103Loveland3\$202101Red Bluff
5\$376104Mt Pleasant3\$202103Loveland
6\$53105Mt Crawford5\$53105Mt Crawford
Sheet

Replies
5
Views
296
Replies
3
Views
420
Replies
4
Views
374
Replies
8
Views
280
Replies
3
Views
226

1,203,693
Messages
6,056,760
Members
444,889
Latest member
ibbara

### 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