Results 1 to 6 of 6

LOOKUP Data across a range of cells to meet a specific criteria.

Threaded View

  1. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: LOOKUP Data across a range of cells to meet a specific criteria.

    I think I got it all, feeling a bit dizzy now...
    I can't help but thinking there must be a better way to structure the data but I have nothing intelligent to add right now.
    Many of these formulas are array formulas, they have to be entered with Ctrl + Shift + Enter. You'll recognice them by the curly brackets {} surrounding them. The brackets can not be added manually, they show up automatically when you enter the formula with Ctrl + Shift + Enter.
    Attached Files Attached Files
    Last edited by Jacc; 09-25-2014 at 06:23 PM.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need to sum cells that meet specific criteria. please help.
    By ben2012 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-03-2013, 02:47 AM
  2. Averaging data if cells in range meet criteria
    By gobbledok in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-24-2013, 02:28 AM
  3. Replies: 2
    Last Post: 11-06-2012, 10:49 PM
  4. move row data to a new tab when cells meet specific criteria
    By brian807 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-10-2012, 10:18 AM
  5. [SOLVED] counting cells in a data range that meet 3 specific conditions
    By bekah7 in forum Excel General
    Replies: 3
    Last Post: 10-01-2005, 02:05 AM

Tags for this Thread

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