two price lists with slight variation on part #

Question

Is there a way that I can compare 2 price list where in some cases one list or the other will compare with a slightly different part #? for example part # A103 and 103 might be the same item and in some cases it is a perfect match 101 and 101

Answer 1

Hi @Jonathan Brotto

Do you mean in your sample, you want to find or search "A103" via "103"?
If so, you can use Countifs to cpmpare the 2 price lists.
On my following sample, the value 1 means the Number and the Price as duplicated. The formula is =COUNTIFS($A$2:$A$6,"?"&D2,$B$2:$B$6,E2).

If you mean "# A103" is the same match as "103", please try following formula, =COUNTIFS($A$2:$A$6,"#*"&D2,$B$2:$B$6,E2).

Any misunderstandings, please let me know.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---