+ Reply to Thread
Results 1 to 2 of 2

help with pulling data from other worksheets

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    help with pulling data from other worksheets

    I need some help:

    sheet 1 has cells a1, b1, c1, d1
    a2, b2, c2, d2
    etc.
    sheet 2 has cells e1, f1, g1, h1
    e2, f2, g2, h2
    etc.

    on sheet 2 i want e1=a1, f1=b1, c1=g1 if d1 is = xxxxx
    e2=a2, f2=b2, c2=g2 if d2 is = xxxxx

  2. #2
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2016
    Posts
    679

    Re: help with pulling data from other worksheets

    on sheet 2 i want e1=a1, f1=b1, c1=g1 if d1 is = xxxxx
    e2=a2, f2=b2, c2=g2 if d2 is = xxxxx


    aren't these reversed? g1=c1 would be consistent, particularly as there is no g1 on Sheet 1



    On Sheet 2 in E1 enter
    =IF($D1="xxxxx",Sheet1!A1,"") then copy across and down

    this puts the data you want in the cell and leaves it blank if xxxxx is not found

    this is not case sensitive

+ 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