+ Reply to Thread
Results 1 to 2 of 2

Tough formula problem

  1. 09-10-2009, 06:40 AM #1
    LovenLust72
    LovenLust72 is offline
    Registered User
    Join Date
    07-19-2004
    Location
    Australia
    MS-Off Ver
    vista and windows 7
    Posts
    9

    Tough formula problem

    I've been asked to assist in finding a way to return certain data from several sheets back to a summary sheet. That in itself is not hard. The only part that makes it hard is that the reference columns A and B that are to be compared to column C and D on the other sheets often have two results. This means a simple VLOOKUP formula will not work. I'm not sure if it is possible with a formula or may need code to make it work somehow.

    So in summary I need column C in the summary sheet to search for a match of column A and B in the summary sheet with Columns C and D respectively in a data sheet that is named the same as C1 on the summary sheet. When a match is found I need the corresponding text in column H to be returned/inserted to column C in the summary sheet. If it ws done as a macro I would need it to continue doing that for each figure in columns A and B on the summary sheet. Then to do the same comparing with sheet matching D1, then E1 etc

    Ok that may be hard to understand but hopefully you get the gist of it
    Reply With QuoteRegister To Reply
  2. 09-10-2009, 07:29 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Tough formula problem

    Hi LovenLust.

    First, be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to edit that post above and change your thread title to something that reflects the CONTENT of your question. Titles should not refer to yourself or opinion, they must be a "searchable" title that reflects the topic. I know you see the benefit of accurate titles, yes? (TIP: don't put in your title until you've finished writing the content, then the title will most likely be self-evident)

    So, be sure to fix that.

    Next, your question indicates a complexity requiring you show us your data AND show us your desired results. So mockup a sample workbook showing the data and your desired results, point out where the results came from if not obvious in your sample data. BEFORE/AFTER sheets are always helpful in finding a speedy resolution.

    Click GO ADVANCED and use the paperclip icon to post up your workbook.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
+ 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.6.0 RC 1