• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 130
  • Last Modified:

Hlookup incorrectly calculating

Folks,
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?
Hlookup.xlsm
0
Frank Freese
Asked:
Frank Freese
  • 2
1 Solution
 
Saqib Husain, SyedEngineerCommented:
You should have

=HLOOKUP($A$3,$C$3:$F$7,(ROW()-3))


The last argument should be 1 for row 4, 2 for row 5 and so on.
0
 
Frank FreeseAuthor Commented:
RATS! I forgot about that. Good catch and thank you very much.
0
 
Frank FreeseAuthor Commented:
thank you
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now