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

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.

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



"Adrian" wrote in message
...
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.