Resolved: Getting Error while making HLOOKUP dynamic

in Introduction to Excel / Excel's Lookup Functions: Vlookup & Hlookup Made Easy

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.

1 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

20 Mar 2023

Hey Kamran,

Thanks for pointing this out! We've fixed it.

Best,

Ned

Helpful answer

Resolved: Getting Error while making HLOOKUP dynamic

Submit an answer

related questions