I have one input sheet use to add data to another sheet(Database). The
input sheet is like a checklist.
In the input sheet, I have one combox box to select the tool id.
Since each tool will have its own spec for each inspection (upper
limit and lower limit), so I would like to change the spec for the
tool once the tool id is change.
How can I feel up the spec based on the tool selected?
Use VLOOKUP function or use MATCH together with INDEX function?

my input sheet is
tool id(combo box)
inspection    upperlimit    lower limit    results
a
b
c

I already keyed the value for each tool spec in another sheet(spec)
the format will be like this:
                             tool1                              tool
2                      tool3 ......
inspection    lower limit  upperlimit     lower limit   upperlimit
a                       0              0.1
0           0.11
b                       1               2
1.2         1.8
c
..