Hlookup incorrectly calculating

Look at the attached workbook. I see nothing wrong in my Hlookup function yet I am not getting the correct results?
I do not understand why?
Frank FreeseAsked:
Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
You should have


The last argument should be 1 for row 4, 2 for row 5 and so on.
Frank FreeseAuthor Commented:
RATS! I forgot about that. Good catch and thank you very much.
Frank FreeseAuthor Commented:
thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.