How do you write the following IF statement using vlookup functionality? Can
I use vlookup function imbedded in an IF statement for this scenario or is
there another function to use?

Look for project number in another worksheet (tab) (within the same
workbook), if project is found (true) return the open date. Else if not
found return the comment "no project found". Open date is stored/defined as
<date,time.

I think the IF statement with vlookup would be written in this manner but
it's not working for me.

=IF(VLOOKUP,B2,Sheet1!C2:C154,1,false),Sheet1!F2:F 154,"no project found")

b2 = project number that vlookup is searching for on worksheet 1, range
c2:c154
sheet1!f2:f154 = is where the open date would be found if the project is
found on worksheet 1.


Thanks,
Rae