+ Reply to Thread
Results 1 to 2 of 2

Excel: How to import numbers from one spreadsheet onto another.

  1. #1
    SLH
    Guest

    Excel: How to import numbers from one spreadsheet onto another.

    I have numbers on one sheet and need to get them to another spredsheet.
    There is a common ID for each corresponding number on both sheets. Basically
    I need to ask if X occurs Y (from the other spreadsheet) needs to appear in
    the selected field.

  2. #2
    Dave Peterson
    Guest

    Re: Excel: How to import numbers from one spreadsheet onto another.

    It sounds like you want =vlookup() or =index(match())

    Take a look at Debra Dalgleish's site:
    http://www.contextures.com/xlFunctions02.html
    and
    http://www.contextures.com/xlFunctions03.html

    SLH wrote:
    >
    > I have numbers on one sheet and need to get them to another spredsheet.
    > There is a common ID for each corresponding number on both sheets. Basically
    > I need to ask if X occurs Y (from the other spreadsheet) needs to appear in
    > the selected field.


    --

    Dave Peterson

+ 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