+ Reply to Thread
Results 1 to 5 of 5

Cross Referencing two spreadsheets? (vlookup)

  1. #1
    Registered User
    Join Date
    09-09-2008
    Location
    MD
    Posts
    4

    Cross Referencing two spreadsheets? (vlookup)

    Hello, first post here I'm a web designer not a excel expert so please bare with me.

    I have two spread sheets, one is a parts list with part numbers and part name.
    Sheet 1
    The second is a warehouse list which has all the part numbers and locations.
    Sheet 2
    Now of course there are multiple part numbers in different locations so right now I have to make a new spreadsheet that counts all the unique part numbers and puts the quantity next to them.
    Sheet 3
    I am then putting this function in sheet1 to look up the quantities from sheet 3.
    =IF(ISERROR(VLOOKUP(B2,Sheet3!A:B,2,0)),"",VLOOKUP(B2,Sheet3!A:B,2,0))

    I would like to bypass the third set and just lookup the quantity from Sheet 2. Is there anyway to do this?

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Have you considered using the COUNTIF function?
    Martin

  3. #3
    Registered User
    Join Date
    09-09-2008
    Location
    MD
    Posts
    4
    This is what I am using to make to Sheet 3
    http://www.pcmag.com/article2/0,1759,1537551,00.asp

    I just have no Idea how I would make a formula to do that at the same time.

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Try

    Please Login or Register  to view this content.
    pasted into cell C2 on sheet1.

  5. #5
    Registered User
    Join Date
    09-09-2008
    Location
    MD
    Posts
    4
    Wow that was so simple, thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Referencing a worksheet on the server using VLOOKUP?
    By OMMBoy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-25-2010, 05:12 AM
  2. Cross referencing 2 workbooks...
    By yeamans17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2008, 10:37 AM
  3. Getting #Div/0! with an if statement referencing a vlookup.
    By hammerhead13 in forum Excel General
    Replies: 3
    Last Post: 07-14-2008, 10:42 AM
  4. Vlookup using two columns-needs to match the first two column
    By pduubb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-01-2008, 01:21 PM
  5. cross referencing
    By n-finite in forum Excel General
    Replies: 2
    Last Post: 11-24-2007, 06:30 PM

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