Results 1 to 12 of 12

Match, Hlookup or?? to relocate and match up data to sorted data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-07-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    202

    Match, Hlookup or?? to relocate and match up data to sorted data

    I'm still playing around with Match and V/Hlookup functions and haven't gotten them fully understood yet, but this should be easy. If I can see it done or see how it works exactly I can normally do it from then on. Not having much luck wit this one though. I have a section that shows data for each month. Jan. thru Dec. I have it sorted from large to small below it. How would I go about taking, say there was 130 in Mar. and that was the largest sorted, then find 130 in the other section and have it find the 130 and Mar. above it from one chart and put the Mar. above the sorted chart? I have a sample to make it easier? If anyone has time to look at it that is. I really would appreciate it.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index MATCH MATCH where I need 2 vlookups and 1 hlookup.
    By zhblack in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-02-2016, 03:30 PM
  2. [SOLVED] HELP! Dynamic data sorted lists Index & Match?!?
    By connmtc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-27-2014, 11:52 AM
  3. match data 2 sheets. if match, then copy data from one sheet to another
    By flunzy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-09-2013, 06:38 AM
  4. Match formula does not work when data is sorted
    By steinfm in forum Excel General
    Replies: 3
    Last Post: 11-22-2011, 09:39 PM
  5. Hlookup and Match or Index and Match?
    By katja328 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-06-2009, 12:33 PM
  6. index,match,match on un-sorted data
    By Brisbane Rob in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-24-2005, 05:04 PM
  7. Replies: 2
    Last Post: 04-06-2005, 07:06 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