+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    10-12-2012
    Location
    Southampton, England
    MS-Off Ver
    365
    Posts
    26

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

    Hi, looking for some help after staring at a Spreadsheet for the morning. I've decided to go back to basics and have had support from yourselves in the past so thought I would call upon it again.

    I've attached an example with steps of what I'm trying to acheive with this Spreadsheet.

    It's a combination of VLOOKUP's across different Worksheet's and in some places up to four IF Statements to determine the correct answer.

    Also on the attached Spreadsheet is a completed table of what I am trying to achieve.

    Many thanks,
    Adam.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-12-2012
    Location
    Southampton, England
    MS-Off Ver
    365
    Posts
    26

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

    Would it help if I tried to explain this a bit better? I might be asking a little too much.

    Regards,
    Adam.

  3. #3
    Registered User
    Join Date
    10-12-2012
    Location
    Southampton, England
    MS-Off Ver
    365
    Posts
    26

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

    Would it help if I tried to explain this a bit better? I might be asking a little too much.

    Regards,
    Adam.

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

    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.

  5. #5
    Registered User
    Join Date
    10-12-2012
    Location
    Southampton, England
    MS-Off Ver
    365
    Posts
    26

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

    Jacc,

    That's brilliant, many thanks for your efforts. I've applied this to a much larger stock list and it's working exactly as I was hoping it would.

    Thanks again,
    Adam.

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

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


    '''''''''''''''

+ 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. 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. 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