Forum Discussion

Copper Contributor

Aug 01, 2017

Solved

Baseball Spreadsheet Help

Hello to anyone who can help. I currently face a problem with my excel worksheet. I am trying to figure this out but to no avail so far. I'll explain the problem and then attach an image. ***IF Corey...

Formulas & Functions

Need Help

Yury Tokarev
Aug 02, 2017
Hi John,

if your lookup data is in sheet named 'Lookup', and you have names in the range A2:A30, Lefty values in the range B2:B30, and Righty values in the range C2:C30, then your formula in the cell K2 of the 'New Hitters' sheet would be
=IF($G2="Left",INDEX(Lookup!$B$2:$B$30,MATCH($A2,Lookup!$A$2:$A$30,0)), INDEX(Lookup!$C$2:$C$30,MATCH($A2,Lookup!$A$2:$A$30,0)))

Yury

John Clifford

Copper Contributor

Aug 02, 2017

Hello Yury,

I will need to use the INDEX/MATCH function because the values are player specific. If you can update the formula that would be awesome.

Thank you,

John

Yury Tokarev

Iron Contributor

Aug 02, 2017

Hi John,

if your lookup data is in sheet named 'Lookup', and you have names in the range A2:A30, Lefty values in the range B2:B30, and Righty values in the range C2:C30, then your formula in the cell K2 of the 'New Hitters' sheet would be

=IF($G2="Left",INDEX(Lookup!$B$2:$B$30,MATCH($A2,Lookup!$A$2:$A$30,0)), INDEX(Lookup!$C$2:$C$30,MATCH($A2,Lookup!$A$2:$A$30,0)))

Yury

John Clifford
Copper Contributor
Aug 02, 2017
Thank you, that was exactly what I was looking for!