Results 1 to 9 of 9

Need simple formula to get data from sheet1 to sheet2

Threaded View

  1. 07-17-2014, 06:20 PM #1
    jmcole
    jmcole is offline
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Need simple formula to get data from sheet1 to sheet2

    I have attached a small version of what I am working on. I need help with this formula.

    The dept numbers in column A on sheet2 are not always in the same order. In the B column of sheet1, I need it to find the dept numbers in column A on sheet1 and Match it with the dept numbers in column A on sheet2 and put the number for that depts grand from column E on sheet2 in column B of sheet1.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-13-2014, 03:20 PM
  2. match data of sheet1 and Sheet2 ColumnA, if matched copy columnB of sheet1 to sheet2
    By annielle_09 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  3. [SOLVED] Simple formula to match column A, sheet1, with column A, sheet2, return text answer
    By Connie5761 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-14-2012, 02:56 PM
  4. [SOLVED] Copying selective data from sheet2 to sheet1 based on the selection made in sheet1.
    By daavis in forum Excel General
    Replies: 3
    Last Post: 06-06-2012, 05:36 AM
  5. Copy cells from Sheet1 into new rows in Sheet2 a simple condition is met.
    By Mayweed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2011, 03:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1