I typed the below formula to make HLOOKUP dynamic. =HLOOKUP($H4,$B$3:$F$7,MATCH(J$3,$B$3:$B$7,0),FALSE) and found discrepancy in "Champions league" name, there is a line changed applied in the result side of the heading, I would appreciate if you correct this and reload the sheet for others. Thank you.

Hey Kamran, Thanks for pointing this out! We've fixed it. Best, Ned

Follow this topic