+ Reply to Thread
Results 1 to 1 of 1

Search 2 diff sheets with diff column headers and identify common names, return entire row

  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    17

    Search 2 diff sheets with diff column headers and identify common names, return entire row

    Hi all,

    I asked for help here once before and was amazed how helpful everyone was. Now I have a problem that I'm not even sure how to describe. Thanks in advance for reading and attempting to help.

    I need to look at two different worksheets with different column headers to find names that match in both. I'd like to isolate those names and their entire corresponding rows on a third sheet, or at least make them easily identifiable within one of those sheets. I don't know how to explain without background, so here:

    Our customers rent oxygen concentrators from us on a monthly basis and we bill their Medicare. These same people can also get portable O2 tanks that can be carried around (a concentrator is stationary). Tanks eventually run out of O2, so we pick them up and replace them as needed or requested by customers (so each customer will have multiple tank orders in the system). Within the first 36 months of renting a concentrator, we cannot bill Medicare for tanks, as this service is included in the rental fee. Beginning in month 37, we may bill for tanks. To track the tanks we deliver, we still need to make an order in the system even if we can't bill. I need to find tank orders made after 36 months of rent so that I can create an order in the system that does bill Medicare.

    So, I ran two reports:
    -Oxygen concentrator rentals in their 37th month of billing or more
    -All portable tank orders company-wide

    I need to cross-reference the two sheets to determine which customers have gotten tanks some time since their 37th month of rent. So I need to align the customers' orders from the portable tank orders sheet with the customers' machine rental on the concentrator sheet to see if those orders occurred at least 36 months after they started using their machine.

    To complicate matters, our Billing team has already identified some of these customers painstakingly and created the order that bills Medicare for the tanks. These orders use the item name (exactly) "GAS". I need to also find these people too so I know not to make duplicate orders.

    I REMOVED NAMES AND CONFIDENTIAL INFO, BUT KEPT THE PATIENT IDs. That is what we'll use as names.

    If you can even understand this, wow. If you can understand it and actually help me, WOW. Thanks for reading, and I hope someone can help. Feel free to ask follow up questions for clarification.

    Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 04-28-2013, 10:09 AM
  2. Replies: 2
    Last Post: 01-13-2013, 06:50 AM
  3. [SOLVED] Help with formula in one column with 2 diff names
    By shilohhoza in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-29-2012, 08:20 PM
  4. [SOLVED] identify unique ID between 2 sheets, auto replace cell values between sheets in diff colum
    By DT123456 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2012, 08:25 AM
  5. Replies: 0
    Last Post: 01-13-2005, 06:49 AM

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