Conditional formatting of cells with dropdownlist

Closed
Report
Posts
1
Registration date
Friday July 5, 2013
Status
Member
Last seen
July 5, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
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