# Multiply Based on Multiple Matching Columns?

#### bundy462

##### New Member
I'm having a hard time doing a lookup to obtain a multiplier based on multiple matching column values. Here is my example.

I have three values in columns G8 through I8. I have a table of values, T8:V42. I need to take the values in G8 thorough I8 and find the correct matching row in T8:V42. Once I know what row matches, I need to take the value in the W column of that matching row and multiply it by J8. My formula will be created in cell L8.

Any help would be appreciated.

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
I'm having a hard time doing a lookup to obtain a multiplier based on multiple matching column values. Here is my example.

I have three values in columns G8 through I8. I have a table of values, T8:V42. I need to take the values in G8 thorough I8 and find the correct matching row in T8:V42. Once I know what row matches, I need to take the value in the W column of that matching row and multiply it by J8. My formula will be created in cell L8.

Any help would be appreciated.

This needs some elaboration. What do you mean by matching G8:I8 against T8:V42 exactly?

This needs some elaboration. What do you mean by matching G8:I8 against T8:V42 exactly?

In the example below, I'm trying to write a formula for cell L8. I need to compare columns G8 through I8 to the T through V columns in the set of values off to the right. When I find the hit (row 17 in this example), I retrieve W17 and multiply it by J8. L8 should equal \$625 in this case. Thank you for your time. (If I could attach the file or a screen shot, it would probably be better.

 T206 Collection - PSA 4 T206 Collection - Backs Player Pose Group Back Ad Subj. Fact. Paid Value Std. Mkt. Rank Back Ad Subj. Fact. Std. Mkt. Cnt. Baker, Frank Follow Through HOF Cycle 460 25 \$250 \$260 1 Broad Leaf 460 25 70 380 0 Beckley, Jake Portrait HOF \$145 2 Lenox (Brown) None 30 65 200 0 Bender, Chief No Trees HOF \$175 3 Uzit None 30 30 100 0 Bender, Chief Portrait HOF \$250 4 Drum 350 25 65 65 0 Bender, Chief Trees HOF \$180 5 Lenox (Black) None 30 17 50 0 Bresnahan, Roger Batting HOF \$180 6 Hindu (Red) None 649 17 45 0 Bresnahan, Roger Portrait HOF \$175 7 Broad Leaf 350 25 8 28 0 Brown, Mordecai Chicago Shirt HOF \$235 8 Carolina Brights None 25 5 15 0 Brown, Mordecai Cubs Shirt HOF \$260 9 Hindu (Brown) None 649 4 14 0 Brown, Mordecai Portrait HOF \$280 10 Cycle 460 25 2.5 13 1 Chance, Frank Batting HOF \$235 11 Piedmont 350-460 42 6 8 0

<colgroup><col style="mso-width-source:userset;mso-width-alt:182;width:4pt" width="5"> <col style="mso-width-source:userset;mso-width-alt:292;width:6pt" width="8"> <col style="mso-width-source:userset;mso-width-alt:182;width:4pt" width="5"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:3949;width:81pt" width="108"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:1389;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1682;width:35pt" width="46"> <col style="mso-width-source:userset;mso-width-alt:1682; width:35pt" span="3" width="46"> <col style="mso-width-source:userset;mso-width-alt:182;width:4pt" width="5"> <col style="mso-width-source:userset;mso-width-alt:292;width:6pt" width="8"> <col style="mso-width-source:userset;mso-width-alt:182;width:4pt" width="5"> <col style="mso-width-source:userset;mso-width-alt:292;width:6pt" width="8"> <col style="mso-width-source:userset;mso-width-alt:182;width:4pt" width="5"> <col style="mso-width-source:userset;mso-width-alt:1426;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:1389;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1572; width:32pt" span="2" width="43"> <col style="mso-width-source:userset;mso-width-alt:1170;width:24pt" width="32"> <col style="mso-width-source:userset;mso-width-alt:182;width:4pt" width="5"> <col style="mso-width-source:userset;mso-width-alt:292;width:6pt" width="8"> <col style="mso-width-source:userset;mso-width-alt:182; width:4pt" span="2" width="5"> </colgroup><tbody>
</tbody>

Last edited:
I've resolved this, the thread can be closed. Thank you!

I've resolved this, the thread can be closed. Thank you!

Great. What is the solution?

I just went with a more simple process of manually assigning the multiplier column to be used as I enter rows into the cells. At the end of the day, this is a spreadsheet to track my baseball card collection and automatically update value. The actual piece that I was trying to figure out to match up the columns is something that I can do manually in about 10 seconds and I only add a new card to my collection about once a month.

Replies
0
Views
74
Replies
12
Views
387
Replies
29
Views
693
Replies
0
Views
118
Replies
7
Views
155

Threads
1,196,368
Messages
6,014,876
Members
441,852
Latest member
ravellig

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

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