Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default VLOOKUP

You're welcome!

Biff

"Nenagh" wrote in message
...
Hi

Thanks very much

Worked a treat
--
Nenagh


"T. Valko" wrote:

Try this:

=IF(ISNA(VLOOKUP(........)),0,VLOOKUP(........))

Biff

"Nenagh" wrote in message
...
Hi, wondering if anyone can help.

I am using the vlookup function and i want 0 returned if an exact match
can
not be found?

Cheers
--
Nenagh