Auto populate cells

Laus · Dec 2, 2006

Can a selection from a drop down menu trigger cosistent info to be input to
cells in the same row?

Gord Dibben · Dec 2, 2006

Laus

Data Validation for the drop-downs and VLOOKUP for the filling-in part.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Gord Dibben MS Excel MVP

Can a selection from a drop down menu trigger cosistent info to be input to
cells in the same row?

Gord Dibben MS Excel MVP

Laus · Dec 2, 2006

Thanks much Gord. I'll go check Debra's site. As of now, I have the data
built into a list and if I click "form",it's all sorted correctly. I'll let
you know how it works out.

Laus · Dec 3, 2006

Hey Gord...I got the dropdown part, but I'm having trouble on the Vlookup.
I'm trying to populate one row, containg six columns of data from a selection
that I make from the drop down menu (included in one of those columns). It
looks like it may need to be the first column and needs to be in ascending
order (is that correct)? I can't seem to get the formula correct? Any
guidance will be greatly apprecated.

Laus · Dec 3, 2006

Got it Gord....thanks a ton. I'll buy u a beer next time i see you!!!!!!

Gord Dibben · Dec 3, 2006

Excellent.........the "got it" part and the "beer" part right behind it.

I guess you figured out if you use a fourth argument of FALSE, the order does
not have to be sorted.

=VLOOKUP(cellref,Table,column,FALSE)

Gord

Got it Gord....thanks a ton. I'll buy u a beer next time i see you!!!!!!

Gord Dibben MS Excel MVP