# two price lists with slight variation on part #

1,076 Reputation points
2022-04-29T19:26:36.433+00:00

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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions

1. 27,601 Reputation points
2022-05-02T06:11:38.523+00:00

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.