G
Guest
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
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