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

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

On Sat, 2 Dec 2006 15:06:00 -0800, Laus wrote:

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

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.

"Gord Dibben" wrote:

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

On Sat, 2 Dec 2006 15:06:00 -0800, Laus wrote:

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

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" wrote:

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.

"Gord Dibben" wrote:

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

On Sat, 2 Dec 2006 15:06:00 -0800, Laus wrote:

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

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

"Laus" wrote:

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" wrote:

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.

"Gord Dibben" wrote:

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

On Sat, 2 Dec 2006 15:06:00 -0800, Laus wrote:

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

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

On Sat, 2 Dec 2006 20:30:00 -0800, Laus wrote:

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

"Laus" wrote:

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" wrote:

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.

"Gord Dibben" wrote:

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

On Sat, 2 Dec 2006 15:06:00 -0800, Laus wrote:

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


Gord Dibben MS Excel MVP