Results 1 to 13 of 13

Using number in one sheet to draw content from another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    40

    Using number in one sheet to draw content from another sheet

    I've tried using the search facility for this but it doesn't seem to be playing ball today.

    I have a column of numbers in one sheet and in the second sheet there are two columns, column a is the corresponding number from the first sheet and column b is the wording for that number. See example below.
    What formula could I use to draw the data from one to sheet to another to make the words replace the numbers in the column of the other sheet?

    Sheet
    102
    107
    119
    145

    Sheet 1
    Column A Column B
    102 Apples
    107 Oranges
    119 Pears
    145 Grapes

    Many thanks
    Mike
    Last edited by mike_m1; 03-05-2010 at 05:32 PM.

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