#N/A query

[Rodney]

Just started Excel today
I organised a simple VLookup
The range is 25,000 names.
Cheating a bit, I pasted the formula I use in MSWorks
and added the "False" because I need the lookup
to give me the ref number on the <first> name in the array it recognises
There may be up to 10 instances in date order in the array

"=IF(ISERR(VLOOKUP(B20150,$B$2:$C$11494,2,FALSE)),"NIL",(VLOOKUP(B20150,$B$2:$C$11494,2,FALSE)))

Everything works suitably, but I would like to get rid of the #N/A
I tried "ERROR.TYPE" which worked OK
but the strange thing is, the #NA was replaced by "-"
and the original correct number in the cell was replaced
by #N/A example
"=IF(ERROR.TYPE(C20152)=7,"-",C20152)

Anybody offer any help please?

 

[Dave Peterson]

Ouch.

Try

=if(iserror(....

There's a small (big for you) difference between =iserr() and =iserror().

Take a look at excel's help and you'll, er, swear outloud!

(we've all been there.)

 

[Rodney]

Ouch! indeed Dave.
Crikey! that was simple,
Thanks, you are a good bloke.



| =if(iserror(....
| There's a small (big for you) difference between =iserr() and =iserror().