Forum Discussion

Oliullah's avatar
Oliullah
Copper Contributor
Dec 06, 2020
Solved

I Need formula in Cell D21 & G21

Hello,

 

The attached file is self explanatory.

 

I Need formula in Cell D21 & G21.

 

Please help me.

 

Thanks in advance.

Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 07, 2020

    Oliullah 

    That's since last parameter is TRUE (approximate match). Please change on FALSE. Even better is to use XLOOKUP or INDEX/MATCH.

7 Replies

  • adversi's avatar
    adversi
    Iron Contributor
    Dec 06, 2020

    Oliullah 

    I would suggest updating your request to make it easier for someone who is having a similar issue as you to find this post. Since you already have the Unique IDs in the DD List tab, the formula you're looking for is VLOOKUP:

     

    =VLOOKUP(D22,$M$18:$O$24,3,FALSE)

     

    FALSE = Exact Match

    TRUE = Approximate Match

     

Resources