View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John James John James is offline
external usenet poster
 
Posts: 2
Default Custom function to simplify vlookup formula

I want to have custom functions that will simplify vlookups (and other
formulas) which have imbedded "if" formulas to eliminate errors. e.g.This
formula provided in a previous posting is ugly and somewhat annoying:
=IF(ISERROR(VLOOKUP($A2,Stock,2,0)),"",VLOOKUP($A2 ,Stock,2,0))

Can I replace it with a custom function that works the same but looks
something like this:
=MyVLookup($A2,Stock,2,0)