Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am hoping someone can help me with this.
I used the DataValidationList function in a particular cell in my spreadsheet. Once that cell returns a particular entry, I want an adjacent cell to populate with the corresponding number. For example. I have a "drop down box" in cell G11. I click on the drop down box and choose option WM6023. Once I have chosen that I want the adjacent cell (H11) to recognize that entry and populate with the number 709. i.e. the number 709 will always be associated with "WM6023" and will automatically populate in cell H11 when "WM6023" is chosen from the "dropdown box" in G11. It also follows that If I choose another entry from the "dropdown box" in G11 a different cooresponding number will appear in H11. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
Excel formulas based upon the color shading of a cell? | Excel Worksheet Functions | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |