View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Felicity Geronimo Felicity Geronimo is offline
external usenet poster
 
Posts: 11
Default vlookup function

Hi,

Is it possible to pass two arguments to a function and then do a
vlookup with the two arguments. One arg would be a cell and the second
arg would be a worksheet named range.

I want to work down a particular column selcecting each cell in turn,
with each active cell i want to lookup that value and check whether it
exists in a named range on a different sheet.

Any ideas please?

Felicity