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 07, 2020

adversi 

 

Hello, 

 

When I select, 

 

1011030534981
1011030534970

 

Excel shows an error message.

 

Could you please help again.

 

Would be expecting for your kind response.

Thanks.

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

    Oliullah 

    As mentioned by Sergei, the last part of the formula should be changed to FALSE. I made the edit to the previous post

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    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.

Resources