+ Reply to Thread
Results 1 to 8 of 8

If or possibly VLookup formula help

  1. #1
    Registered User
    Join Date
    01-06-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    26

    If or possibly VLookup formula help

    Hi, trying to get it so the green boxes will auto calculate from the table and the current scores. Thank you in advance
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-07-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    290

    Re: If or possibly VLookup formula help

    Hi LRGy,

    Can you please include the expected output?

    Regards,

  3. #3
    Registered User
    Join Date
    01-06-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: If or possibly VLookup formula help

    Hi, added the expected outcome below. Thanks
    Attached Files Attached Files

  4. #4
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: If or possibly VLookup formula help

    Is that you want?
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    02-07-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    290

    Re: If or possibly VLookup formula help

    Quote Originally Posted by LRGy View Post
    Hi, added the expected outcome below. Thanks
    Hi,
    I am really not sure about your logic

  6. #6
    Registered User
    Join Date
    01-06-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: If or possibly VLookup formula help

    Hi

    Sorry I will give more detail.

    Column's ABCDE, depending on the numbers in the "Current Scores" cell, I need it to put the Points number in the Green box.

    i.e. In cell D18, as the current score is 70% (cell D16) is will be zero, if the current score cell had 85% it would have 4 points in the green box.

    The Current Score boxes for each area (ABCDE) change depending on other factors but I want to calculate what the Points are from the matrix table for each column.

    I want the green boxes to show the current number of points in each area.

    I hope that explains it more but if you need more info please let me know.

    Thanks

  7. #7
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: If or possibly VLookup formula help

    Hi
    Your data must be sorted in ascending order and without empty rows.
    Use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    where J7:J9 are 3, 4 and 5
    L7:L9 are 80%, 85%, 90%.

    You can copy these to the right.
    see the file Book1 (17).xlsx
    Regards

  8. #8
    Registered User
    Join Date
    01-06-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: If or possibly VLookup formula help

    Thank you Jose - that is perfect

+ 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. Vlookup with index/match possibly.
    By Kramxel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2015, 06:06 AM
  2. Replies: 5
    Last Post: 06-25-2014, 09:43 AM
  3. Having trouble creating a formula using VLOOKUP, possibly, to compile information
    By needhelpfast7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-30-2013, 12:38 AM
  4. Vlookup possibly
    By lian.cragg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2011, 02:50 PM
  5. Replies: 2
    Last Post: 04-05-2010, 05:13 PM
  6. Vlookup across sheets, nested Vlookup possibly?
    By paid2mkgrlspanic in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-09-2009, 05:10 PM
  7. Possibly vlookup
    By Carleilam in forum Excel General
    Replies: 2
    Last Post: 02-03-2008, 06:03 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