# Match?

#### Silvermini63

##### Active Member
Ok I am having an absolute mental blank I have a result of a Min \$ sell price in column K and the formula I am after for column L (which I have manually typed the correct answer) is where did that price come from link wise from line by line.

So for example the first price of \$101.62 (k2) came from Link 1 in A2
If you look at K6 the price of \$42.66 came from Link 6 in D6.

I hope this is clear and thanks for any help in advance
Excel Workbook
ABCDEFGHIJKL
28354
Excel 2010

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### AhoyNC

##### Well-known Member
Is this what you are trying to do?

Excel Workbook
ABCDEFGHIJKL
Sheet1

#### iliace

##### Well-known Member
I think your first condition is wrong, it looks like th price came from Link 3 in C2.

If this is correct (unless I'm missing something), one possible formula in L2 would be:

=INDEX(\$A2:\$E2, MATCH(INDEX(\$A\$1:\$E\$1, MATCH(\$K2, \$F2:\$J2, 0)), \$A\$1:\$E\$1))

#### Silvermini63

##### Active Member
Thank you for your help and I was spewing how easy it was and how bad my mental block

Replies
1
Views
357
Replies
2
Views
241
Replies
15
Views
455
Replies
1
Views
209
Replies
5
Views
2K

1,190,873
Messages
5,983,337
Members
439,839
Latest member
iblackie

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