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

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,686
Members
412,481
Latest member
nhantam
Top