1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • VLOOKUP + IF ?

    From Claus Busch@21:1/5 to All on Wed Nov 18 20:47:26 2020
    Hi Amy,

    Am Wed, 18 Nov 2020 11:26:29 -0800 (PST) schrieb Amy H:

    So if A contains a certain word, it will pull out the category from another category table (C=categorize, D= the word)

    If A contains word "CPC", then I would like to have it categorized as "Shipping" next to the word "CPC".

    CPC l Shipping
    Pen l Office supplies

    try:
    =INDEX(Sheet2!C:C,MATCH(A2,Sheet2!$D$1:$D$100,0))

    In the newer version you also could use: =XLOOKUP(A2,Sheet2!$D$1:$D$100,Sheet2!$C$1:$C$100,"",0)


    Regards
    Claus B.
    --
    Windows10
    Office 2016

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Amy H@21:1/5 to All on Wed Nov 18 11:26:29 2020
    Does anyone know how to use Vlookup and If function together?

    So if A contains a certain word, it will pull out the category from another category table (C=categorize, D= the word)

    If A contains word "CPC", then I would like to have it categorized as "Shipping" next to the word "CPC".

    CPC l Shipping
    Pen l Office supplies

    Seems pretty basic but can't figure out how.
    Thanks in advance!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)