Need Formula

john jay

New Member
Joined
Dec 1, 2005
Messages
2
I have a excel spreadsheet with my inventory on it. Every day I receive a updates from my supplier that has all the current item #‘s. So this means item #‘s are no longer there because they go out of sock and new # ‘s appear for new products.. The number do not match up just by sorting them. I’m looking for a formula in excel to help me match up my item # ‘s with my suppliers # ‘s.. I know excel has formulas but I do not know how to work it...

Column A supplier item #'s to match column B my item #'s..
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
john jay said:
I have a excel spreadsheet with my inventory on it. Every day I receive a updates from my supplier that has all the current item #‘s. So this means item #‘s are no longer there because they go out of sock and new # ‘s appear for new products.. The number do not match up just by sorting them. I’m looking for a formula in excel to help me match up my item # ‘s with my suppliers # ‘s.. I know excel has formulas but I do not know how to work it...

Column A supplier item #'s to match column B my item #'s..

John,

Can you download Colo's utility and post some sample data and expected results?
 

john jay

New Member
Joined
Dec 1, 2005
Messages
2
..SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT>
Book1
ABCD
24931849318
34934449344
45280549344
55421452805
65422854214
75424254228
85424354240
95424454242
105642254243
115644054244
125652254244
135771454244
1454245
1556385
1656422
1756423
1856440
1956522
2057714
Sheet1
Book1
ABCD
24931849318
34934449344
449344
55280552805
65421454214
75422854228
854240
95424254242
105424354243
115424454244
1254244
1354244
1454245
1556385
165642256422
1756423
185644056440
195652256522
205771457714
Sheet1




I would like paste item #'s in A and have it automatically find its = value.

I have around 2500 item #'s. Column A has only current and new item #'s that change day to day. Column B has current and deactivated #'s.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,805
Messages
5,833,766
Members
430,230
Latest member
Yimmie

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top