Choosing the tool and a alternate

[ktspapa]

I hava a workbook that has 2 worksheets. Worksheet 1 contains a list of master blanks and their Outside Diameter sizes (range name MasterBlank)
Example: (OD = Column A and Master Blank = Column B)


Column A
OD
10.759
10.760
11.000
11.500
11.935
11.940
11.950
12.550
12.630
12.950
13.000

Column B
Tool 15
Tool 14
Tool 13
Tool 12
Tool 11
Tool 10
Tool 9
Tool 8
Tool 7
Tool 6
Tool 5
Tool 4



Worksheet 2 contains a table of sizes that are blanked from the material fallout which comes from Worksheet 1.
Column A
Part Size
13.646
12.750
12.730
12.594
12.050
12.000

Column B
Tool 4
Tool 6
Tool 6
Too l7
Tool 8
Tool 8

Using =VLOOKUP(A2,MasterBlank,2,TRUE) in B2 of worksheet 2 returns a tool size too small, Tool 4 is 13.000 and will not be large enough to make a 13.646 OD part.
The problem I am havin is VLOOKUP finds the first instance which is smaller. I need to find the next size equal to or larger.
Can someone help?
This is part 1 Choosing the Tool.