Hello,
For the excel file in the attachment i am trying to do the following, but i don't seem to find the answer:
Based on choosing a product type, (p1, p2, p3, ... pn) data will be taken from that sheet only, doing the following.
In the first sheet i can input W and H, and using those W and H as coordinates, a value will be automatically given.
Example: P1 values: if i imput in the first list H of 2250 and W of 1830, i want to see the value coresponding to those coordinates, that is 423, in my case.
BUT if the value is greater, i want it to choose the next line or the next column,... and based on the example above, let's say i need a H of 2252 with 1830, i want to be given the answer 433.
If i am not understood, correctly, please ask for additional info
Thank you,
Cristian
Bookmarks