Multiply Based on Multiple Matching Columns?

[bundy462]

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.

 

[Aladin Akyurek]

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?

 

[bundy462]

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>

 

[bundy462]

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

 

[Aladin Akyurek]

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

Great. What is the solution?

 

[bundy462]

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.