Closed Thread
Results 1 to 4 of 4

Need formula Index and Match that pulls data from column from another sheet

  1. #1
    Registered User
    Join Date
    03-23-2014
    Location
    Houston
    MS-Off Ver
    Excel 2013
    Posts
    1

    Need formula Index and Match that pulls data from column from another sheet

    Need formula Index and Match that pulls data from column from another sheet.

    1st sheet index 4 fields.
    End calculation on 1st sheet
    Search's 2nd sheet, match's the 4 fields trying to Match then inserts calculation results in another column on Sheet 2 into Sheet 1. If you can solve this problem, I will have additional calculations in the next 4-5 days to complete the data sheet.
    Last edited by hitecfom@gmail.com; 03-23-2014 at 03:17 PM. Reason: Unless you want a ton of spam email

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,774

    Re: Need formula Index and Match that pulls data from column from another sheet

    Hi,

    You'll need to upload the workbook here along with some reference notes.

    If this is part of a larger project which you think will need more input than typically happens here then consider putting it in the Commercial Forum.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,743

    Re: Need formula Index and Match that pulls data from column from another sheet

    Hi and welcome to the forum

    I have removed your email address, and if you feel the need to pay for your answers, we have Commercial Services forum where you can pay for answers.

    If your WB contains senstiove info, I suggest you create a dummy WB, showing the type of daya you have, and what your answer would look like - you can upload the WB here
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Need formula Index and Match that pulls data from column from another sheet

    Thread close as OPposted in Commercial Services Sub Forum.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 14
    Last Post: 01-15-2014, 09:42 AM
  2. Extract data from one sheet to another (Index/Match Formula)
    By pauldaddyadams in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2013, 06:51 PM
  3. Replies: 0
    Last Post: 09-17-2012, 11:12 AM
  4. [SOLVED] Index/match formula to return data to summary sheet
    By pauldaddyadams in forum Excel General
    Replies: 9
    Last Post: 09-12-2012, 05:33 PM
  5. Replies: 6
    Last Post: 09-08-2005, 05:38 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1