hlookup #N/A
 

I can't figure out why I am getting #N/A for this.

=hlookup(A1, range of the table, 2) returns #N/A, but when I replace the
lookup value with the value in A1 it returns the correct answer.

Please help me. : (

See the first tip he
http://www.officearticles.com/excel/...soft_excel.htm
It's a very common problem, perhaps it's what's happening to you.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"stacyjhaskins" wrote in message
...
I can't figure out why I am getting #N/A for this.

=hlookup(A1, range of the table, 2) returns #N/A, but when I replace the
lookup value with the value in A1 it returns the correct answer.

Please help me. : (

That suggest that A1 has some extraneous spaces, probably at the end.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stacyjhaskins" wrote in message
...
I can't figure out why I am getting #N/A for this.

=hlookup(A1, range of the table, 2) returns #N/A, but when I replace the
lookup value with the value in A1 it returns the correct answer.

Please help me. : (