Thread: Help understanding Variables in an IF/VLOOKUP statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SIR Knight SIR Knight is offline
external usenet poster
  
Posts: 27
Default Help understanding Variables in an IF/VLOOKUP statement
Keri,

In you Vlookup, I assume that your "ClientList" is a named range in a
worksheet.

If this is the case then you need to code it to say

Application.Vlookup(Cells(i,16),Range("ClientList" ),1,False)

Thanks

Steve

Reply With QuoteReply With Quote