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.

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

 

Oliullah's avatar
Oliullah
Copper Contributor
Dec 08, 2020

adversi Thank you

Resources