+ Reply to Thread
Results 1 to 4 of 4

(VLOOKUP) Merging Two Sheets with Common Column A Values

  1. #1
    Registered User
    Join Date
    10-01-2010
    Location
    Why do you need to know this?
    MS-Off Ver
    Excel 2003
    Posts
    3

    (VLOOKUP) Merging Two Sheets with Common Column A Values

    I have 1 XLS file, which contains two sheets.

    SHEET1:
    A: PartNumber
    B: Price

    SHEET2:
    A: PartNumber
    B: Price

    Sheet1 has data for both PartNumber (A) and Price (B), but Sheet2 only has PartNumbers (A) and Price (B) is an empty column.

    I am trying to populate Col B in Sheet2 with prices, where Sheet2-A matches Sheet1-A.

    NOTE: All columns have a header (A = PartNumber and B = Price).
    Last edited by elbrian; 10-01-2010 at 11:50 AM.

  2. #2
    Registered User
    Join Date
    10-01-2010
    Location
    Why do you need to know this?
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Need Help with a Super-Simple Function

    SAMPLE OF WHAT I'M WORKING WITH:

    Sheet1:
    PartNumber | Price
    06255-PVJ-315 | 100
    06255-RGL-305 | 20.45
    06255-RGR-315 | 40.35

    Sheet2:
    PartNumber | Price
    01464-XVJ-000 |
    01864-XRJ-000 |
    01564-XGJ-000 |

    ( | serves as a column separator, in my sample)

    There are thousands of rows on each sheet.
    Last edited by elbrian; 10-01-2010 at 11:30 AM.

  3. #3
    Registered User
    Join Date
    10-01-2010
    Location
    Why do you need to know this?
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: (VLOOKUP) Merging Two Sheets with Common Column A Values

    I wound up doing this all via PHP (importing data into tables, using scripts to manage the joining, export to CSV). Thanks for nothing!

  4. #4
    Registered User
    Join Date
    09-30-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: (VLOOKUP) Merging Two Sheets with Common Column A Values

    Index , match function will help u. Pl see attached sheet
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1