Help to write out a vlookup then If formula

tjtanya

New member
Joined
Jun 23, 2013
Messages
1
Reaction score
0
Points
0
Hello,
I have a vlookup formula in Sheet1 looking up a name in Sheet2 but I want to then apply IF to it but I don't know how.

e.g. =vlookup(A2,CustomerName,3,FALSE) then I want it to do this IF(ReviewDate="","Review Complete",ReviewDate)

So look up a name then return text "Review Complete" if the cell beside the name is blank but if there is a date in the cell, return that date.
But I don't know how to join them in the one formula. Can anyone help me write it out in correct formula
Thanks so much
tjtanya
 
Top