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

[LB_UK]

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]

Comparing two sheet.
goto

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

here download the file play1

may you can get your anwere from it.

ni****h desai

 

[LB_UK]

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

 

[AJ]

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.