Results 1 to 2 of 2

Thread: Help with Lookup formula

  1. #1
    Neophyte adnansajid33's Avatar
    Join Date
    Jul 2019
    Posts
    1
    Articles
    0
    Excel Version
    Office 365

    Help with Lookup formula



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

    Hi all,

    I am new to excel and learning on how to create a formula that would allow me to:

    1. Look up Column AC1
    2. If Column AC1 has the following peoples name: Ajay Devgan, Tom Cruise, John Smith
    3. Then Return FDI on Column H
    4. ELSE return whatever the existing value is for Column AC1

    Thank you for your help

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,652
    Articles
    0
    Excel Version
    O365
    In H2

    Code:
    =IF(ISNUMBER(MATCH(ACI2,{"Ajay Devgan";"Tom Cruise";"John Smith"},0)),FDI2,ACI2)

Posting Permissions

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