Find A Value based on multiple columns and single cells with data separated by a comma

L

Lynderlou

New Member
Joined
Feb 8, 2018
Messages
5
Hi

I have a spreadsheet with a set of criteria in it. I have called it table 1

I have a second set of data I will call Table 2.

I would like to be able to insert the appropriate value in the PRICE column in table 2 based on the criteria listed in table 1 and matching it to a set of values found in table 1 vs 2. Perhaps just showing what I am trying to do is best as I think I am not being clear in my description. Any help would be appreciated
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 1108"]
<colgroup><col><col><col><col><col><col span="8"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Table 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Table 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Output[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Name[/TD]
[TD="align: left"]Car[/TD]
[TD="align: left"]Year[/TD]
[TD="align: left"]Price[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Name[/TD]
[TD="align: left"]Car [/TD]
[TD="align: left"]Year[/TD]
[TD="align: left"]Price[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Mark[/TD]
[TD="align: left"]Altima[/TD]
[TD="align: right"]2008[/TD]
[TD="align: right"]10000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Mark[/TD]
[TD="align: left"]Altima[/TD]
[TD="align: right"]2008[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Mark, Tom[/TD]
[TD="align: left"]Camry[/TD]
[TD="align: right"]2010[/TD]
[TD="align: right"]5000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Mark[/TD]
[TD="align: left"]Camry[/TD]
[TD="align: right"]2010[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]John, Tom[/TD]
[TD="align: left"]Model X[/TD]
[TD="align: right"]2011[/TD]
[TD="align: right"]11000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Tom[/TD]
[TD="align: left"]Camry[/TD]
[TD="align: right"]2010[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Tony[/TD]
[TD="align: left"]Altima[/TD]
[TD="align: right"]2008[/TD]
[TD="align: right"]8000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]John[/TD]
[TD="align: left"]Model X[/TD]
[TD="align: right"]2011[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: left"]John[/TD]
[TD="align: left"]F-150[/TD]
[TD="align: right"]2016[/TD]
[TD="align: right"]20000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Tom[/TD]
[TD="align: left"]Model X[/TD]
[TD="align: right"]2011[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]Tony[/TD]
[TD="align: left"]Altima[/TD]
[TD="align: right"]2008[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"]John[/TD]
[TD="align: left"]F-150[/TD]
[TD="align: right"]2016[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
This formula also works very well. Now my challenge is to understand each a little better so to determine if one might be better for the actual task than the other. Thanks Aladin Akyurek for posting your formula as well
 
Upvote 0

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Lynderlou said:
This formula also works very well. Now my challenge is to understand each a little better so to determine if one might be better for the actual task than the other. Thanks Aladin Akyurek for posting your formula as well
Click to expand...

I'm glad to help and thank you for the feedback.

Ps: do many tests with all formulas before to use one.

Markmzz
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
Multiple Search Criteria in Excel Table
Replies
4
Views
164
KOKOSEK
KOKOSEK
A
  • Question Question
Need to convert value depending on currency and date
Replies
2
Views
571
deLockloire
D
N
  • Question Question
Color duplicates rows in two different sets of data and also the rows which are present in both sets of data.
Replies
0
Views
486
Noob_Excel
N
S
  • Question Question
Help on complicated VBA code
Replies
3
Views
774
superfb
S
skyh3ck
  • Question Question
1st match column header, 2nd lookup a value in same column, 3rd return corresponding value from the very first column ?? need help
Replies
2
Views
629
skyh3ck
skyh3ck

Forum statistics

Threads
1,226,735
Messages
6,192,733
Members
453,752
Latest member
Austin2222

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