VLookup issue

[Guest]

The results of the Vlookup formula gives an N/A unless you click in each particular cell & press enter. What could be causing the formula not to work correctly & what can we do to correct this

This is something that seems to happen on a regular basis. Thank you in advance for your help.

 

[Frank Kabel]

Hi
do you use VLOOKUP on a number?. sounds like a formating issue. If
you're looking for numbers try the following:
- select an empty cell and copy this cell
- select your column with the lookup values
- goto 'Edit - Paste Special' and select the action 'Add'

now try VLOOKUP again

--
Regards
Frank Kabel
Frankfurt, Germany

The results of the Vlookup formula gives an N/A unless you click in

each particular cell & press enter. What could be causing the formula
not to work correctly & what can we do to correct this?

This is something that seems to happen on a regular basis. Thank you

in advance for your help.

 

[Carlos]

the match not exist in the range
if you use the 4th argument for the funtion "FALSE", the match is exact, if
the 4th "TRUE" you don't have N/A, but the match is approximate

The results of the Vlookup formula gives an N/A unless you click in each

particular cell & press enter. What could be causing the formula not to
work correctly & what can we do to correct this?

This is something that seems to happen on a regular basis. Thank you in

advance for your help.

 

[Alex Ballingall]

-----Original Message-----
The results of the Vlookup formula gives an N/A unless

you click in each particular cell & press enter. What
could be causing the formula not to work correctly & what
can we do to correct this?

This is something that seems to happen on a regular

basis. Thank you in advance for your help.

.
Most likely the result of data not being entered. A

solution is to use the "If(iserror)" function. E.G.=IF
(ISERROR(VLOOKUP(A8,$I$7:$J$15,2))," ",VLOOKUP
(A8,$I$7:$J$15,2)). This checks for an error message and
prints a blank space( or anything you want) in the cell.