My problem is similar to this issue here
I've tried getting this to work for my issue but I can only seem to get it to work with a single value returned....I need several options returned.
I need to take the 3 values (case dimensions) in A4, B4 and D4 and generate a list of 8-10 case sizes from my Case Inventory tab that fit the bill.
ie: the first number (case length) can to be 317mm +51mm/-2mm (if the -2 mucks up the ability to find numbers then ignore it)
the second number (case width) can to be 297mm +51mm/-2mm (if the -2 mucks up the ability to find numbers then ignore it)
the third number (case depth) can to be 175mm +51mm/-0
I've fought with this all weekend and half the day today and I am at my wits end.
I've tried so many different version of the answer supplied on the attached link but I'm supplying it as a start point because for this guy's issue we know it worked.
Mine were too many and too wrong to even bother starting with them.
My spreadsheet is attached.
Thanks in advance for any and all help offered.
Bookmarks