Bit convoluted but here goes.
Insert two new rows 2:3, with values in C2:C3 of Height and Width
Insert a new column in D with a value of '-999x999 in D1
In D2, =VALUE(LEFT(D1,FIND("x",D1)-1)) copied across to K2
In D3, =VALUE(MID(D1,FIND("x",D1)+1,99)) copied across to K3
In E8, add this array formula
=MATCH(MIN(ABS(IF($D$2:$K$2=INDEX($D$2:$K$2,MATCH(MIN(ABS($D$2:$K$2-A8)),ABS($D$2:$K$2-A8),0)),$D$3:$K$3,9999)-B8)),ABS(IF($D$2:$K$2=INDEX($D$2:$K$2,MATCH(MIN(ABS($D$2:$K$2-A8)),ABS($D$2:$K$2-A8),0)),$D$3:$K$3,9999)-B8),0)
and copy down to E24
In D8, =INDEX($D$1:$K$1,E8) and copy down to E24
I get different results to you after D21.
Bookmarks