Forum Discussion
Baseball Spreadsheet Help
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
Hi John,
you can use the following formula in cell K2
=IF($G2="Left","ReplaceWithYourLeftyValue","ReplaceWithYourRightyValue")
Once you have put it there, you can copy it down to the other cells in the row.
This assumes that you your Righty and Lefty values are not player specific. In case they are player specific, you would need to use INDEX/MATCH to lookup the values for each player. Please let me know if this the case, and I will send you an updated formula.
If you find my answer useful and like it, I would appreciate you clicking the 'Like' button :)
Regards
Yury
.png){kind=link}
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
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
- Thank you, that was exactly what I was looking for!