This user had the formula =OR(IF(D2="Victory","15",""),IF(D2="Draw","10",""),IF(D2="Defeat","7","")) trying to return 15/10/7 if column D contained Victory/Draw/Defeat. Unfortunately, that's not how the OR() function works – it returns TRUE if any of the passed arguments are TRUE and FALSE if all of the passed arguments are FALSE. Here are 4 ways to actually get the desired output: =IF(D3="Victory",15,IF(D3="Draw",10,IF(D3="Defeat",7,))) =IFS(D4="Victory",15,D4="Draw",10,D4="Defeat",7) =SWITCH(D5,"Victory",15,"Draw",10,"Defeat",7,) =XLOOKUP(D6,I5:I7,J5:J7,) with a lookup table with the Keys / Output Personally I would use SWITCH() in this instance, and the XLOOKUP() table version with more options. Music courtesy of CORTEXX #googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide I use Bandicam to record, Clipchamp to edit, and a Blue Yeti microphone Donate on Paypal: @