I Need formula in Cell D21 & G21

[Oliullah]

Hello,

The attached file is self explanatory.

I Need formula in Cell D21 & G21.

Please help me.

Thanks in advance.

[#2]

@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

[#3]

@adversi Thanks a lot.

[#4]

@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.

[#5 · Accepted solution]

@Oliullah 

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

[#6]

@Oliullah 

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

[#7]

@adversi Thank you

[#8]

@Sergei Baklan Thank you