How do I compare two sheets and add a code number from one t
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

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

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com