Need Formula

[john jay]

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

 

[Brian from Maui]

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]

..SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT>

Book1
	A	B	C	D
2	49318	49318
3	49344	49344
4	52805	49344
5	54214	52805
6	54228	54214
7	54242	54228
8	54243	54240
9	54244	54242
10	56422	54243
11	56440	54244
12	56522	54244
13	57714	54244
14		54245
15		56385
16		56422
17		56423
18		56440
19		56522
20		57714
Sheet1

Book1
	A	B	C	D
2	49318	49318
3	49344	49344
4		49344
5	52805	52805
6	54214	54214
7	54228	54228
8		54240
9	54242	54242
10	54243	54243
11	54244	54244
12		54244
13		54244
14		54245
15		56385
16	56422	56422
17		56423
18	56440	56440
19	56522	56522
20	57714	57714
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.