F
fruitchunk
I need help to do a vlookup with if statement together
Sheet 1 - Column A: Dates, Column B: Names:, Column C: Control Numbers,
Sheet 2 - Column A: Dates, Column B: Names, Column C: Code Numbers,
In Column D on sheet 2, I want to see the Control Number for the specific
Name and specific Date.
This is what I have in D1 =IF(A1=Sheet1!A:A,VLOOKUP(B1,Sheet1!$A$1:$C$100,3))
Instead of getting the Control Number I get FALSE
What am I doing wrong? Can you please help?
Sheet 1 - Column A: Dates, Column B: Names:, Column C: Control Numbers,
Sheet 2 - Column A: Dates, Column B: Names, Column C: Code Numbers,
In Column D on sheet 2, I want to see the Control Number for the specific
Name and specific Date.
This is what I have in D1 =IF(A1=Sheet1!A:A,VLOOKUP(B1,Sheet1!$A$1:$C$100,3))
Instead of getting the Control Number I get FALSE
What am I doing wrong? Can you please help?