SOLVED

# I Need formula in Cell D21 & G21

Occasional Contributor

# I Need formula in Cell D21 & G21

Hello,

The attached file is self explanatory.

I Need formula in Cell D21 & G21.

7 Replies

# Re: I Need formula in Cell D21 & G21

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

# Re: I Need formula in Cell D21 & G21

Hello,

When I select,

 1011030534981 1011030534970

Excel shows an error message.

Would be expecting for your kind response.

Thanks.

Best Response confirmed by Oliullah (Occasional Contributor)
Solution

# Re: I Need formula in Cell D21 & G21

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

# Re: I Need formula in Cell D21 & G21

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