Home |
Search |
Today's Posts |
#1
|
|||
|
|||
error N/A
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? |
#2
|
|||
|
|||
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 __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|