Using Vlookup and If functions simultaneously

V

Vlookup and If

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

Sean Timmons

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?
 
V

Vlookup and If

Is it possible to do the vlookup first and then based on what is in the cell
apply the if function?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With VLOOKUP 2
VLOOKUP & Data Validation 0
vlookup formatting problem 1
Can I add a formula or function to Vlookup? 1
VLOOKUP Not working 3
Excel - Wich Function should I use? 1
Dragging a formula down isn't working - where am I going wrong? 1
Vlookup a subtotal 2

Top