Vlookup with multiple inputs?

[hollandrob81]

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?


[TABLE="class: grid, width: 500"]
<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>[TR]
[TD="width: 98, colspan: 2"]UJ
[/TD]
[TD="width: 42"]A[/TD]
[TD="width: 34"]AD
[/TD]
[TD="width: 26"][/TD]
[TD="width: 321, colspan: 5"][/TD]
[TD="width: 240, colspan: 2"][/TD]
[TD="width: 240, colspan: 2"][/TD]
[TD="width: 240, colspan: 2"][/TD]
[/TR]
[TR]
[TD]Sparex[/TD]
[TD]Kramp[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2444[/TD]
[TD][/TD]
[TD="align: right"]54.8[/TD]
[TD="align: right"]22[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2445[/TD]
[TD][/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]27[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2446[/TD]
[TD][/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]34[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2447[/TD]
[TD][/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]24[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]2448[/TD]
[TD][/TD]
[TD="align: right"]74.5[/TD]
[TD="align: right"]27[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2449[/TD]
[TD][/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]2458[/TD]
[TD][/TD]
[TD="align: right"]106.5[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2496[/TD]
[TD][/TD]
[TD="align: right"]106.5[/TD]
[TD="align: right"]35[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]2497[/TD]
[TD][/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2498[/TD]
[TD][/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]22[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2499[/TD]
[TD][/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6450[/TD]
[TD][/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]32[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]6451[/TD]
[TD][/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]36[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

</tbody>

 

[Aladin Akyurek]

What is the outcome you require for the sample you posted? Are UJ, A, and AD column names or just headers?

 

[hollandrob81]

the sample i posted was the raw data for the lookup to use. the ultimate result would be the number in the UJ column. whihc im hooping to have on a different sheet to the raw data. but my problem lies in the multiple options for (i.e) 30 being 92, 106.5 or 80, with the displayed result 2449, 2458 or 2499. when entering "30" in the A cell on my main sheet, i would be presented with 3 options before i could come up with the final result of the 4 digit number. hope that helps! many many thanks in advance

 

[hollandrob81]

i want to be able to enter a number in A or AD

 

[Aladin Akyurek]

I don't get it. I was simply asking for the results which must obtain for the sample you posted.