Previous Topic Next Topic

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 1863 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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel format
D -
sheryljohnson -

1 response