Please need help!!

[cashchris2005]

Hello All,

I have a question.... I am trying to make a spreadsheet that will allow me to have a combo box/or data validation list box, and based on the selection out of the combo box/list box, excel will automatically fill in other cells using information from another spreadsheet. Is this possible?

Example
Combo box in A1 asks if user wants standard process or new process. User selects standard process (on spreadsheet #1)

I now want cell A2 To automatically say 1 PSI, cell A3 to say 100C, and cell A4 to say 5 meters

This information will be located on spreadsheet #2 in the same work book.

Is this possible, or am I asking to much of excel?

 

[SteveO59L]

Have a look at vlookup()

 

[cashchris2005]

Hello Thank you for responding to my question... So I guess my next question is how would the vlookup formula fit for an example like this

The combo box isn't showing up below But hopefully you get my drift. The combo box would allow the person to select option 1, option 2, or option 3. And based on their selection, it would automatically fill in cells D1,E1,F1, and G1 like this below. Option 1 is selected now



<table border="0" cellpadding="0" cellspacing="0" width="576"><col style="width:48pt" span="9" width="64"> <tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:48pt" height="20" width="64">A1</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">D1</td> <td style="width:48pt" width="64">E1</td> <td style="width:48pt" width="64">F1</td> <td style="width:48pt" width="64">G1</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" align="left" height="20" valign="top">

<table cellpadding="0" cellspacing="0"> <tbody><tr> <td style="height:15.0pt;width:48pt" height="20" width="64">Select your Choice</td> </tr> </tbody></table> </td> <td>
</td> <td>
</td> <td>Bacon</td> <td>Eggs</td> <td>Cheese</td> <td>Sausage</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> <td>
</td> <td>Yes</td> <td>Yes</td> <td>No</td> <td>No</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="8" style="height:15.0pt;mso-ignore:colspan" height="20">Option 1 would be Yes to Bacon, and Yes to Eggs, and No to Cheese and Sausage</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="9" style="height:15.0pt;mso-ignore:colspan" height="20">Option 2 Would be Yes to Eggs and Yes to Cheese, and no to Bacon, and no to sausage</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="9" style="height:15.0pt;mso-ignore:colspan" height="20">Option 3 would be yes to Cheese and yes to sausage, and no to bacon and no to eggs</td> </tr> </tbody></table>

Thank you again!!

 

[SteveO59L]

So somewhere in your sheet (say aa:ad) tabulate your option relationship.

then for d1 your vlookup() would be something like

=vlookup(a1,aa:ad,2,false)

 

[cashchris2005]

Ok Steve, so im a little lost lol... (Im not to familiar with advanced excel other than sums lol).

So I do understand putting the vlookup function in cells D2, E2,F2 & G2, but what I don't understand is the aa:ad part? I am not understanding what you mean when you say tabulate your option relationship...

Like what does putting aa:ad on my sheet do?

I guess based on my example sheet below about the eggs/sausage/bacon/cheese. A2 being the option combo box and cells D2,E2,F2,G2 would be automatically populated with Yes or No based on the selection of the combo box in A2.

Thanks again Steve

 

[SteveO59L]

Send me a pm with your e-mail address and I'll send you a worked example