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.

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

Resources