×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Hlookup function error

Hlookup function error

Hlookup function error

(OP)
I am trying to use the Hlookup function in Xcell and I'm haveing trouble. the lookup value is from a cell that used the roundup function and it keeps giving me "NA". I did the same formula using Hlookup with the round down function and it works perfect. Can anyone shed some light? I have attached the xcell sheet to view the formula.Cell E17 is the cell with the error.

Thanks in advance!

RE: Hlookup function error

If you change the argument in E17 from false to true, I think it will work.

Also, in E20, I'm not sure why you have all the parentheses.  Try to clean it up to E17 -( )/( )/( )

RE: Hlookup function error

(OP)
Magoo2,

Thanks it works perfect now! Do you know the logic behind true vs false in this case?

RE: Hlookup function error

No, I'm afraid I don't.  Usually I read the logic behind the arguments and my understanding leads me to always use the wrong one.  So I usually try them both ways.

RE: Hlookup function error

From help on HLOOKUP:

"Range_lookup   is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, HLOOKUP will find an exact match. If one is not found, the error value #N/A is returned."


So the question it is asking is "do you want to accept an approximate match?"

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: Hlookup function error

Also if the True/False is omitted your list must be sorted in ascending order.
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources