View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Using Vlookup and If functions simultaneously

Depends on the If you want!

If(I3="",VLOOKUP(J2,Sheet1!A:E,4,0),0)

Are you attempting to accomplish something that we can help with?

"Vlookup and If" wrote:

Is it possible to use Vlookup and If functions together in one formula? If
so, please give an example.