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