# Formula

#### imthatonegirl

##### New Member
I am sorry if this has already been answered, I am not sure what to search for.

I am trying to do something like a VLOOKUP, take a value to find and return data from a table.
The problem is the initial lookup value will show up multiple times in the search table and I will need to choose between those values.

Can anyone please help me create a formula for this?

P.S. I could not add an image.
https://imgur.com/a/LiJ8pXf

Last edited:

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
I don't want to look at your link, sorry (other people might be willing to).

How will you decide which of the multiple matching entries to choose from ?

Excel 2013/2016
ABCDEFG
1SellerproductEmp 1Emp 2Emp 3Emp 4
2Emp 1V1V1V2V7V4
3Emp 2V2V3V6
4Emp 1V3V5V8
5Emp 4V4
6Emp 1V5
7Emp 2V6
8Emp 3V7
9Emp 2V8
A1
Cell Formulas
RangeFormula
D2=IFERROR(INDEX(\$B\$2:\$B\$9,AGGREGATE(15,6,(ROW(\$A\$2:\$A\$9)-ROW(\$A\$2)+1)/(\$A\$2:\$A\$9=D\$1),ROWS(\$1:1))),"")

Formula copied down & across

Correction! Now it is, I will play with that thank you!

For some reason, that formula is not returning any results at all.

Last edited by a moderator:
You're welcome & thanks for the feedback

Replies
0
Views
131
Replies
4
Views
17
Replies
1
Views
56
Replies
3
Views
184
Replies
1
Views
69

1,203,739
Messages
6,057,089
Members
444,904
Latest member
SelamT

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

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