Who's an excel guru? Auto-filling values

Discussion in 'OT Technology' started by driftwell, Aug 31, 2005.

  1. driftwell

    driftwell New Member

    Joined:
    Oct 7, 2003
    Messages:
    220
    Likes Received:
    0
    I've got a good 1500+ line spreadsheet (spreadsheet A). Another spread sheet that contains a "master price list" (spreadsheet B).

    What i want to do is create some kind of auto-fill via formula or macro that will:

    automatically fill in prices (we'll say column H of spreadsheet A) based off of part numbers in column B of spreadsheet A)

    using spreadsheet B which has part #s in column A and prices in column B

    anyone? I'll be googling while i wait for a reply from someone :)
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
  3. LBZ

    LBZ Not Me = Not a problem

    Joined:
    May 7, 2001
    Messages:
    152
    Likes Received:
    0
    Location:
    Mission Viejo, CA
  4. driftwell

    driftwell New Member

    Joined:
    Oct 7, 2003
    Messages:
    220
    Likes Received:
    0
    gotcha.... figured it out with the "vlookup" function

    thanks guys
     

Share This Page