Match?

S

Silvermini63

Active Member
Joined
Sep 25, 2006
Messages
293
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
1Link 1Link 2Link 3Link 4Link 5Link 1Link 2Link 3Link 4Link 5Min $From Link
2Link 1Link 2Link 3Link 4Link 5101.62101.62Link 3
3Link 1Link 3Link 4Link 5Link 88.858.85Link 4
4Link 2Link 3Link 5Link 6Link 947.5047.50Link 9
5Link 1Link 2Link 5Link 8Link 1126.0127.0026.01Link 1
6Link 2Link 4Link 5Link 6Link 74542.6642.66Link 6
7Link 1Link 2Link 3Link 4Link 524.9925.0024.99Link 1
28354
Excel 2010
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Is this what you are trying to do?

Excel Workbook
ABCDEFGHIJKL
1Link 1Link 2Link 3Link 4Link 5Link 1Link 2Link 3Link 4Link 5Min $From Link
2Link 1Link 2Link 3Link 4Link 5101.62101.62Link 3
3Link 1Link 3Link 4Link 5Link 88.858.85Link 4
4Link 2Link 3Link 5Link 6Link 947.547.5Link 9
5Link 1Link 2Link 5Link 8Link 1126.012726.01Link 1
6Link 2Link 4Link 5Link 6Link 74542.6642.66Link 6
7Link 1Link 2Link 3Link 4Link 524.992524.99Link 1
Sheet1
 
Upvote 0
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))
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Match Lookup Formula
Replies
3
Views
227
awoohaw
awoohaw
K
  • Solved
VBA Copy certain cells and columns to another sheet
2
Replies
16
Views
383
karl10220
K
K
  • Solved
Update to existing Move data macro
2
Replies
11
Views
272
Alex Blakenburg
A
A
  • Solved
#REF! error when using INDEX MATCH
Replies
5
Views
104
Fluff
Fluff
A
  • Question
Help with scanning barcodes into an excel invoice
2
Replies
12
Views
589
RoryA
RoryA

Forum statistics

Threads
1,214,830
Messages
6,121,835
Members
449,051
Latest member
excelquestion515

Share this page

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