Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with drop box please!!
ok, I was asked to make a value, lets say AA have a drop box that means
mislocation of part. So that when you type AA you will have the drop box come down telling you what it means. I have no idea how to do this though. can someone plesae help me! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with drop box please!!
You could use VLOOKUP to display the description corresponding to the value.
If value "AA" is entered in A1 then in B1 put: =Vlookup(A1,sheet2!A1:B50,2,false) In Sheet2 in columns A & B set up a table of Values (in column A) and description (in columnB); change range to suit. To allow for values not found use: =if(iserror(Vlookup(A1,sheet2!A1:B50,2,false)),"", Vlookup(A1,sheet2!A1:B50,2,false)) HTH "meegan" wrote: ok, I was asked to make a value, lets say AA have a drop box that means mislocation of part. So that when you type AA you will have the drop box come down telling you what it means. I have no idea how to do this though. can someone plesae help me! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with drop box please!!
Ok i guess im just not that smart at using excel. Ok so someone will type in
AA. As soon as someone types in AA, my supervisor wants a drop box to come down under AA stating what it means. I have the abbreviatiions and meanings set up in A1=B1 order and they are in sheet 4 and im working in External, which is the name of the sheet. So im trying to figure out how to do that "Toppers" wrote: You could use VLOOKUP to display the description corresponding to the value. If value "AA" is entered in A1 then in B1 put: =Vlookup(A1,sheet2!A1:B50,2,false) In Sheet2 in columns A & B set up a table of Values (in column A) and description (in columnB); change range to suit. To allow for values not found use: =if(iserror(Vlookup(A1,sheet2!A1:B50,2,false)),"", Vlookup(A1,sheet2!A1:B50,2,false)) HTH "meegan" wrote: ok, I was asked to make a value, lets say AA have a drop box that means mislocation of part. So that when you type AA you will have the drop box come down telling you what it means. I have no idea how to do this though. can someone plesae help me! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with drop box please!!
Change sheet2 to sheet4 in the VLOOKUP formula. In "External" A2 (assuming AA
is entered in "External" A1) put the Vlookup formula. When you type AA in A1, description will appear in A2. I don't see the need for dropdown box as you are not selecting the description. Sheet4 table will look like: A B AA Mislocation of parts BB No parts CC Wrong part HTH "meegan" wrote: Ok i guess im just not that smart at using excel. Ok so someone will type in AA. As soon as someone types in AA, my supervisor wants a drop box to come down under AA stating what it means. I have the abbreviatiions and meanings set up in A1=B1 order and they are in sheet 4 and im working in External, which is the name of the sheet. So im trying to figure out how to do that "Toppers" wrote: You could use VLOOKUP to display the description corresponding to the value. If value "AA" is entered in A1 then in B1 put: =Vlookup(A1,sheet2!A1:B50,2,false) In Sheet2 in columns A & B set up a table of Values (in column A) and description (in columnB); change range to suit. To allow for values not found use: =if(iserror(Vlookup(A1,sheet2!A1:B50,2,false)),"", Vlookup(A1,sheet2!A1:B50,2,false)) HTH "meegan" wrote: ok, I was asked to make a value, lets say AA have a drop box that means mislocation of part. So that when you type AA you will have the drop box come down telling you what it means. I have no idea how to do this though. can someone plesae help me! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |