Solved

Hlookup incorrectly calculating

Posted on 2013-11-22
3
118 Views
Last Modified: 2013-11-22
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
Comment
Question by:Frank Freese
  • 2
3 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39668962
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
 

Author Comment

by:Frank Freese
ID: 39668988
RATS! I forgot about that. Good catch and thank you very much.
0
 

Author Closing Comment

by:Frank Freese
ID: 39668990
thank you
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now