Thread: how can i use the ISNA and Vlookup funtions in a macro?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
  
Posts: 486
Default how can i use the ISNA and Vlookup funtions in a macro?
You can but you don't have to...

=if(isna(vlookup(This, InThat, 2,false)), "Not Found", vlookup(This, InThat,
2,false))

or you can use CountIf

=if(countif(InThat, This)=0, "Not Found", vlookup(This, InThat, 2,false))

I prefer the second method, but it is up to you...
--
HTH...

Jim Thomlinson


"Jack" wrote:

I would like to use the Vlookup function in a macro, and the ISNA function.
Can this be done?
Reply With QuoteReply With Quote