Results 1 to 2 of 2

Thread: Help to write out a vlookup then If formula

  1. #1

    Help to write out a vlookup then If formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,461
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •