hollandrob81
New Member
- Joined
- Feb 4, 2011
- Messages
- 18
hello everyone. im trying to get excel to look up a value from a list of possibilities. to give you some context im trying to create a spreadsheet to show me the possible universal joint bearings from a given measurement, either A or AD, with A being the measurement across the bearing, and AD being the diameter of the bearing cap. there are only a certain number of combinations I.E if the AD was 30 then the possible values for A would be 92, 106.5 or 80. now i know how to create a Vlookup using the raw data in the table below, but i only know how to do it if theres only one possible answer, but i want a drop down box or radio button option for the possible options. could someone please help me?
<colgroup><col style="mso-width-source:userset;mso-width-alt:1792; width:37pt" width="49" span="2"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1243;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:2230;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2230;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:2340;width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2450;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:4425;width:91pt" width="121"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:4425;width:91pt" width="121"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:4425;width:91pt" width="121"> </colgroup><tbody>
</tbody>
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
</tbody>
UJ | A | AD | |||||||||||||
Sparex | Kramp | ||||||||||||||
2444 | 54.8 | 22 | |||||||||||||
2445 | 70 | 27 | |||||||||||||
2446 | 90 | 34 | |||||||||||||
2447 | 61 | 24 | |||||||||||||
2448 | 74.5 | 27 | |||||||||||||
2449 | 92 | 30 | |||||||||||||
2458 | 106.5 | 30 | |||||||||||||
2496 | 106.5 | 35 | |||||||||||||
2497 | 80 | 30 | |||||||||||||
2498 | 54 | 22 | |||||||||||||
2499 | 92 | 30 | |||||||||||||
6450 | 76 | 32 | |||||||||||||
6451 | 89 | 36 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:1792; width:37pt" width="49" span="2"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1243;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:2230;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2230;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:2340;width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2450;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:4425;width:91pt" width="121"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:4425;width:91pt" width="121"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:4425;width:91pt" width="121"> </colgroup><tbody>
</tbody>
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
</tbody>