I have a table and a function. This table has 4 columns and 4 rows. Here are the columns:
16 24 36 48
16
24
36
48
That is my table. The information on the inside is populated by a formula. The columns and rows listed are the perimeter of the table and let’s say at 36X36, I can produce 48 parts and it’s the goal I’m trying to reach, I have a function that looks in to that table and looks for the “goal”. What I need is I need to know which outer perimeter numbers make up that “goal”. Here is the example:
16 24 36 48
16
24
36 48
48
Is there anyway to get 36 and 36 from 48? Is there a HLOOKUP or VLOOKUP I can use to get 36 and 36 just from finding 48? I know it’s alot of info, if you would liketo get more involved, email me at: jwhitlock@starprecision.com. Thanks,