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,...
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,...
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,...
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 ...
Yury 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 ...
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...
VLOOKUP(G2, lookupSheetName!$A$1:$B:$2, 2, FALSE) Here: "lookupSheetName" is the name of the sheet in your workbook from where you want to pick up the desired corresponding values for LEFT/RIGHT. You can replace the cell range in the formula - "$A$1:$B:$2" with the range ...
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...
VLOOKUP(G2, lookupSheetName!$A$1:$B:$2, 2, FALSE) Here: "lookupSheetName" is the name of the sheet in your workbook from where you want to pick up the desired corresponding values for LEFT/RIGHT. You can replace the cell range in the formula - "$A$1:$B:$2" with the range ...