Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. : ( |
#2
|
|||
|
|||
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. : ( |
#3
|
|||
|
|||
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. : ( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HLOOKUP FUNCTION | Excel Worksheet Functions | |||
keep the formatting of the cell found using Hlookup | Excel Discussion (Misc queries) | |||
Vlookup and Hlookup | Excel Worksheet Functions | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel | |||
SUMIF - HLOOKUP Combination | Excel Worksheet Functions |