VBA - Searching for a value in a matrix table

Hi all,

I have a matrix table of Shutters. Those shutters can vary in height and width.

The matrix table presents the prize of a shutter with a specific height (round-up) and width (round-up).

I can't figure out how to search for a prize in the matrix table with the given height and width.

For example i have a shutter with a height of 1550 mm and a width of 860. the VBA script has to find the correct prize in the matrix.
So in this case the correct prize should be 170 because the 1550 is rounded up to 1600 and the 860 is rounded up to 900

Can someone please help me?
Matrix table search.jpg

One way...

Please Login or Register  to view this content.