You know card collecting is your happy place when, no matter what’s going on in life; how hard your day is, how much you have on your plate, etc., that nothing replaces the joy felt in the presence of wax and cardboard.
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,...
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 ...
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 ...
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...