If inside if(vlookup)

[Yweiss0]

Hello,
I need some help, I have a worksheet and in one cell I check if it equals to 0 it should do vlookup to other sheet and get from there the information. But I want to add to it that if the vlookup is also equals to 0 so it should do antoher vlookup to another worksheet and get the information from there.
So itz should be something like this:
In column F I have names of the workers and in column J I have the last day they worked this year and if the last day was last year it will vlookup the name from worksheet2 (last year) but if the vlookup get 0 so it means the last time they worked is 2 years ago it will do vlookup to the name in worksheet3 (two years ago) and will find the date. All workshhet are same so the names are always in column F and the dates are always in column J
If j2=0 do vlookup to worksheet2 and if the vlookup in worksheet2 is also equals to 0 do vlookup to worksheet3 and get the information from worksheet3.
Thanks...

 

[Joe4]

I think you will want to structure it like this:

=IF(J2=0,IF(VLOOKUP1=0,VLOOKUP2,VLOOKUP1),"what you want returned if J2<>0")

Substitute VLOOKUP1 with your first VLOOKUP formula, and VLOOKUP2 with your second VLOOKUP formula.