vlookup using a constant value
 

I'm getting #n/a after using a constant value (one I just type into a cell)
as the lookup value for the vlookup function. Here's the statement:
=VLOOKUP(H7,WONUMS!A2:C83,2,FALSE)
H7 is where I type in my value. WONUMS! is a second sheet that has my array.

If I set column H as some kind of conditional value then it works: for
example if I have the values in column H compare to see if there's a date in
column G and return if value if true then the vlookup statement works.

Any help is hugely appreciated!!!

Thanks,

Jesse

sorry if this is duplicate, I previously posted a question but it didn't
appear

Usual problems with =vlookup() are numbers treated as text or different number
of spaces in the value (leading/trailing/embedded).

You may want to share what's in H7 and what you type in manually.

If it is numeric,

=vlookup(123,WONUMS!A2:C83,2,FALSE)
will be different than:
=vlookup("123",WONUMS!A2:C83,2,FALSE)

Debra Dalgleish has some more tips like this at:
http://www.contextures.com/xlFunctions02.html


cutthroatjess wrote:

I'm getting #n/a after using a constant value (one I just type into a cell)
as the lookup value for the vlookup function. Here's the statement:
=VLOOKUP(H7,WONUMS!A2:C83,2,FALSE)
H7 is where I type in my value. WONUMS! is a second sheet that has my array.

If I set column H as some kind of conditional value then it works: for
example if I have the values in column H compare to see if there's a date in
column G and return if value if true then the vlookup statement works.

Any help is hugely appreciated!!!

Thanks,

Jesse

sorry if this is duplicate, I previously posted a question but it didn't
appear

--

Dave Peterson

Thanks Dave!

Debra's Instructions worked great. I was entering a number into H7, and the
table contained what I thought were numbers. If I converted it to text as
Debra suggested, then it looked up the value just fine.

Thanks Again!

Jesse Geis

"Dave Peterson" wrote:

Usual problems with =vlookup() are numbers treated as text or different number
of spaces in the value (leading/trailing/embedded).

You may want to share what's in H7 and what you type in manually.

If it is numeric,

=vlookup(123,WONUMS!A2:C83,2,FALSE)
will be different than:
=vlookup("123",WONUMS!A2:C83,2,FALSE)

Debra Dalgleish has some more tips like this at:
http://www.contextures.com/xlFunctions02.html


cutthroatjess wrote:

I'm getting #n/a after using a constant value (one I just type into a cell)
as the lookup value for the vlookup function. Here's the statement:
=VLOOKUP(H7,WONUMS!A2:C83,2,FALSE)
H7 is where I type in my value. WONUMS! is a second sheet that has my array.

If I set column H as some kind of conditional value then it works: for
example if I have the values in column H compare to see if there's a date in
column G and return if value if true then the vlookup statement works.

Any help is hugely appreciated!!!

Thanks,

Jesse

sorry if this is duplicate, I previously posted a question but it didn't
appear

--

Dave Peterson