I have the following in a table format (corresponding range is C3:G4):
Total term end ann dis
1.5% 2.0% 2.5% 3.0% 3.5%
On cell C6 I have a list with options: Total, term, end, ann, dis.
For one of my calculations, I need to know which percentage to use based on C6 value so I'm using HLOOKUP(C6,C3:G4,2) but I'm getting the wrong answers - the percentage being looked up is wrong. What am I doing wrong?
Like other lookup functions, if you omit the 4th argument in the HLOOKUP() function (https://support.office.com/en-us/art...5-e1ad662ed95f ), then Excel expects the data in the 1st row to be sorted in ascending order. Your data are clearly not. If you will always be looking for an exact match to lookup_value, then add the 4th argument=FALSE to your HLOOKUP() function.
Originally Posted by shg
Thanks, FALSE argument made it work
Please don't crosspost.
http://www.mrexcel.com/forum/excel-q...t-working.html
and see the link below for the reason why.
http://www.excelguru.ca/content.php?184
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks