Return Max or Min value based on criteria

My first post. Have searched quite a bit, but not finding 'exactly' what I'm looking for.

ColA
1
1.1
1.1.1
1.1.2
1.2
1.2.1
1.2.2

ColB
5
10
15
20
25
30
35

I want to be able to look up and return min or max values based on matching left "x" number of string characters, where "x" is based on the length of the string I entered.

Entries would return results as follows (for max):

1 would return 35 (because all criteria values start with 1).
1.1 would return 20 (max of items starting with 1.1).
1.1.1 would return 15.
1.2 would return 35.

Appreciate any help.

Welcome to the forum! Try this for the min:

Please Login or Register  to view this content.

...and this for the max:

Please Login or Register  to view this content.

Row\Col	A	B	C	D	E
1	1	5		Enter Key:	1.1
2	1.1	10		Min:	10
3	1.1.1	15		Max:	20
4	1.1.2	20
5	1.2	25
6	1.2.1	30
7	1.2.2	35