error N/A

[nospam]

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?

[Richard Buttrey]

On Mon, 12 Sep 2005 23:32:41 +0100, nospam <[email protected]>
wrote:

>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?


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

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

[nospam]

Thank you Richard, I owe you a beer.


Richard Buttrey <[email protected]> writes
>On Mon, 12 Sep 2005 23:32:41 +0100, nospam <[email protected]>
>wrote:
>
>>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?
>
>
>=IF(ISERROR(VLOOKUP(AJ43,$A$3:$AG$28,33,FALSE)),"",VLOOKUP(AJ43,$A$3:$AG
>$28,33,FALSE))
>
>Rgds
>__
>Richard Buttrey
>Grappenhall, Cheshire, UK
>__________________________