How can one cell be autopopulated by another cell and have a drop.

G

Guest

I need to have cell #2 be autopopulated by cell #1 and also be able to have a
drop down menu to be able to autopopulate cell #1.

If one have of the information is known but not the other I want the ability
to query using either cell.
 
J

JulieD

Hi Adrian

bit confused ...
do you want

...................A..............................B....................................................................C
1.........<Drop down list>...........<value derived from drop down
list>..............=IF(A1="",B1,A1)

the problem with this is if you put a formula in B1 which relates to the
selected value in A1 if you over type it with a value (the only way i can
see B1 will have a value and A1 not) then you'll lose your formula.

the drop down list in A1 can be created via data / validation - check out
www.contextures.com/tiptech.html for lots of ideas and if B1 you can use
some sort of formula depending on how it is related to A1.

Hope this gives you some ideas
Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can a cell have a drop down list and can also be auto populated 1
Drop Down List 3
Formatted cell column in drop down list 1
Drop Down Menu 11
drop down data want to choose more than one item for cell 1
Conditional Drop Down boxes 2
Odd Drop Down Box Behavior 4
Can selection from text drop-down dictate value in another cell 3

Top