How do I compare two sheets and add a code number from one t

LB_UK · Mar 21st, 2002, 02:26 AM

I have two worksheets.sheet1(the order sheet)can contain the type of info shown here.(variable quantity 2-1000 rows)
A B C D
Code Item1 Item2 Item3
1158 1 0 0
1215 0 1 0
1220 1 0 0
1332 0 0 1

Sheet2. contains the master list of codes with addresses. (up to 1000 rows)in addition sheet2 contains an additional business code for each address. (see below) Basically I need to compare the two lists by code and have the business number inserted into the order sheet beside the correct code.In col.E

Sheet2
A B C
Bus.Num. Code Address
101 1158 etc.etc.
102 1159 etc.etc.
103 1202
104 1215

[ This Message was edited by: LB_UK on 2002-03-22 04:35 ]

nisht · Mar 21st, 2002, 04:43 AM

Comparing two sheet.
goto

http://www.pexcel.com/guestdownload.htm

here download the file play1

may you can get your anwere from it.

nishith desai

LB_UK · Mar 22nd, 2002, 05:46 AM

I've tried to get on http://www.pexcel.com but get the page not found message.
Any other ideas please

AJ · Mar 22nd, 2002, 05:58 AM

Sounds like you want to use VLOOKUP, although I'm not that familiar with it myself.
If on sheet 2 you moved the code to column A instead (with Bus.Num. in column B), then on Sheet1, the formula in cell E2 would be
=VLOOKUP(A2,Sheet2!A2:C1000,2,FALSE)

HTH.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 02:26 AM	#1
LB_UK New Member Join Date: Mar 2002 Posts: 20	I have two worksheets.sheet1(the order sheet)can contain the type of info shown here.(variable quantity 2-1000 rows) A B C D Code Item1 Item2 Item3 1158 1 0 0 1215 0 1 0 1220 1 0 0 1332 0 0 1 Sheet2. contains the master list of codes with addresses. (up to 1000 rows)in addition sheet2 contains an additional business code for each address. (see below) Basically I need to compare the two lists by code and have the business number inserted into the order sheet beside the correct code.In col.E Sheet2 A B C Bus.Num. Code Address 101 1158 etc.etc. 102 1159 etc.etc. 103 1202 104 1215 [ This Message was edited by: LB_UK on 2002-03-22 04:35 ]

Mar 21st, 2002, 04:43 AM	#2
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	Comparing two sheet. goto http://www.pexcel.com/guestdownload.htm here download the file play1 may you can get your anwere from it. nishith desai

Mar 22nd, 2002, 05:46 AM	#3
LB_UK New Member Join Date: Mar 2002 Posts: 20	I've tried to get on http://www.pexcel.com but get the page not found message. Any other ideas please

Mar 22nd, 2002, 05:58 AM	#4
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Sounds like you want to use VLOOKUP, although I'm not that familiar with it myself. If on sheet 2 you moved the code to column A instead (with Bus.Num. in column B), then on Sheet1, the formula in cell E2 would be =VLOOKUP(A2,Sheet2!A2:C1000,2,FALSE) HTH.