Conditional formatting of cells with dropdownlist

Closed
amrita.misra Posts 1 Registration date Friday July 5, 2013 Status Member Last seen July 5, 2013 - Jul 5, 2013 at 12:39 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 6, 2013 at 12:46 AM
In column C of my spreadsheet i have created a drop down of a set of 96 locations in US. When i select a certain location from the drop down , i want column E , G & I to populate with a defined set of numbers . These numbers form the source data for my final calculation . Need help with step by step guidance on how can i achieve this ?

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 6, 2013 at 12:46 AM
you prepare a data base of 96 loation and their numbers (are there three numbers then have it in the next 3 colmns)



suppose in A1 a location is entered
then use VLOOKUP in B1
0