+ Reply to Thread
Results 1 to 4 of 4

Google Sheets: Can't build box size matrix to work with formula to auto select box size

  1. #1
    Registered User
    Join Date
    07-10-2020
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    2

    Google Sheets: Can't build box size matrix to work with formula to auto select box size

    I'll answer questions instantly to help you help me

    Hello, I have a google sheets query. Although I think the solution will work for both excel and google sheets. Really desperate for some help

    Attached is a sheet where in, COPY OF FROZEN PRINTING tab column I I'm trying to achieve something which appears to be simple but I'm a bit of a noob and can't figure it out.

    For example in I3 it used to take the number of F3 & H3 to look into the matrix/index table in BOX SIZES tab, to return a box size. We now have a third type of item (COUNT 2P), G3 which is about 1.5x the size of COUNT 1P items and i need to take it into account now as boxes used will be larger.

    What i tried to do is make a third MATCH syntax/clause which would use G3 to look up the same range as F3 and bring back the result (but G3 would be x1.5 a number used in another formula).

    It was G3,'Box Sizes'!$B$2:$AG$2

    Problem is, I3 only returns the same value it would if there was nothing in G3.

    I'm expecting it to return as L as 12 COUNT 1P would return 12.

    I'm currently unsuccessfully using this:
    Please Login or Register  to view this content.
    I even attempted an array but i couldnt get it to work

    please help

    thank you
    Attached Files Attached Files
    Last edited by DendetheNameknoob; 07-10-2020 at 07:59 AM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,937

    Re: Google Sheets: Can't build box size matrix to work with formula to auto select box siz

    Hello DendetheNameknoob and Welcome to Excel Forum.
    To display "L" in cell I3 the formula could read either:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or since both F3 and H3 are 1*:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    *The later is an array formula.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    07-10-2020
    Location
    London, England
    MS-Off Ver
    Google Sheets
    Posts
    2

    Re: Google Sheets: Can't build box size matrix to work with formula to auto select box siz

    Thank you

    It wouldn't change the box size if the number it was looking for wasn't a whole number.
    Besides that, it did work

    I found a simpler solution - thank you for your help

    DENDE

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,937

    Re: Google Sheets: Can't build box size matrix to work with formula to auto select box siz

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Auto select varying range of cells that may change size for VBA mail code
    By Joven76 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-29-2016, 12:34 AM
  2. Size frequency matrix to individual size list
    By jrmetzger in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-18-2016, 06:52 AM
  3. [SOLVED] Build Column D based on Columns A, B, and C (which have varying size and content)
    By amanzi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2016, 11:43 AM
  4. Using auto-size with forms - need to size based on text!
    By AnnaG87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2014, 11:51 AM
  5. Eigenvector of matrix for nxn matrix of variable size
    By rocketscientist165 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2014, 10:51 AM
  6. Auto size a pivot table to a page size
    By *.* in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2006, 12:09 AM
  7. Auto Size Phot to Cell Size
    By Corey in forum Excel General
    Replies: 1
    Last Post: 05-30-2006, 04:55 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