error N/A

G

Guest

Hi,
I am using the following formula in a cell AJ44

=IF(AJ43<>"",VLOOKUP(AJ43,$A$3:$AG$28,33,FALSE),"")

if I have a value in aj43 that is not in the vlookup table range then
aj44 shows #n/a, if I then delete the value in aj43 the cell aj44 shows
as empty.

how can I make the cell AJ44 be blank but still leave a value in aj43?
 
R

Richard Buttrey

Hi,
I am using the following formula in a cell AJ44

=IF(AJ43<>"",VLOOKUP(AJ43,$A$3:$AG$28,33,FALSE),"")

if I have a value in aj43 that is not in the vlookup table range then
aj44 shows #n/a, if I then delete the value in aj43 the cell aj44 shows
as empty.

how can I make the cell AJ44 be blank but still leave a value in aj43?
Click to expand...


=IF(ISERROR(VLOOKUP(AJ43,$A$3:$AG$28,33,FALSE)),"",VLOOKUP(AJ43,$A$3:$AG$28,33,FALSE))

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
G

Guest

Thank you Richard, I owe you a beer.


Richard Buttrey said:
=IF(ISERROR(VLOOKUP(AJ43,$A$3:$AG$28,33,FALSE)),"",VLOOKUP(AJ43,$A$3:$AG
$28,33,FALSE))

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Click to expand...
 
Top