On Mon, 12 Sep 2005 23:32:41 +0100, nospam
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
__________________________
|