+ Reply to Thread
Results 1 to 2 of 2

Thread: How do I look up data on another workbook and copy across

  1. 05-04-2009, 03:57 PM #1
    tweacle
    tweacle is offline
    Registered User
    Join Date
    08-02-2005
    Posts
    21

    How do I look up data on another workbook and copy across

    Can anyone help.

    I have a workbook which has 3 sheets named up/down/sheet 3. What im trying to is look in row 8 in sheets 1 and 2 for a unique code I.E 2H00 (up).

    What I need to do then is to look in sheet 3 in column B for that unique code and then copy over the diagram no shown in A to the column concerned and put in row 66.

    To explain better I have 2 workbooks called before and after and this shows better what I want.

    Can anyone assist.

    Thanks
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 05-04-2009, 06:18 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    02-15-2008
    Location
    Grappenhall, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    6,566

    Re: How do I look up data on another workbook and copy across

    Hi,

    In row 66 cells starting in C66 and copied across, use the following

    =INDEX(Sheet3!A:A,MATCH(C$8,Sheet3!$B:$B,FALSE),1)
    Rgds
    Richard Buttrey

    If this was useful then please rate it appropriately.

    Click the small star icon at the bottom left of my post.
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0