W
WStoreyII
how do you set up a cell to contain a look up value?
WStoreyII
WStoreyII
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
try
=vlookup(a2,lookuprange,column,false)
=vlookup(a2,lookuprange,column,false)
W
WStoreyII
what i am trying to do is set it up so that when i click on a cell i see a
list of items maybee ten or twelve in access i can type in the values of
that list i dont know how do to that in excel
WStoreyII
list of items maybee ten or twelve in access i can type in the values of
that list i dont know how do to that in excel
WStoreyII
W
wiseman
I think you may want 'data validation' here are some instructions.
http://www.contextures.com/xlDataVal01.html
Barbara
http://www.contextures.com/xlDataVal01.html
Barbara
W
WStoreyII
That is what I need, however the instuctions say to type a name for the
range in the formula bar my formula bar is not showing and i dont know how
to get it back
range in the formula bar my formula bar is not showing and i dont know how
to get it back
W
wiseman
Try View and tick (check) formula bar.
However you do not type the range name in the formula bar, but in the box to
its left (but it is on the same line and does disappear with the formula
bar).
Barbara
However you do not type the range name in the formula bar, but in the box to
its left (but it is on the same line and does disappear with the formula
bar).
Barbara