vlookup or other
 

I'm creating a new sheet to assign shifts for my employees. I want to have a
drop down in one cell where I can pick shift times then in the next cell,
have the hours automatically picked in assiciation with the shift. I've
already created the drop down using validation but am not sure how to get the
second cell to automatically picks the hours associated with the shift. Is
this a vlookup function or other?

Hi

maybe this is what you're looking for
http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

"brodiemac" wrote in message
...
I'm creating a new sheet to assign shifts for my employees. I want to
have a
drop down in one cell where I can pick shift times then in the next cell,
have the hours automatically picked in assiciation with the shift. I've
already created the drop down using validation but am not sure how to get
the
second cell to automatically picks the hours associated with the shift.
Is
this a vlookup function or other?

Very close and thank you for the suggestion. I'm not looking for a dropdown
in the second cell. I want the second cell to auto-populate with data
associated with what was selected in the drop down in the first cell.

"JulieD" wrote:

Hi

maybe this is what you're looking for
http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

"brodiemac" wrote in message
...
I'm creating a new sheet to assign shifts for my employees. I want to
have a
drop down in one cell where I can pick shift times then in the next cell,
have the hours automatically picked in assiciation with the shift. I've
already created the drop down using validation but am not sure how to get
the
second cell to automatically picks the hours associated with the shift.
Is
this a vlookup function or other?

Hi

then you can use the VLOOKUP function

assuming you have a table somewhere (maybe sheet 2) with
...........A..................B................... ......C
1.....Shift...............Start Time............End Time
2.....AM..............06:00....................... .18:00

etc
then with your drop down on sheet 1 cell A1
click in B1 (or where you want the start time returned to) and type
=VLOOKUP(A1,Sheet2!$A$2:$C$10,2,0)
for the end time it would be
=VLOOKUP(A1,Sheet2!$A$2:$C$10,3,0)

hope this helps
Cheers
JulieD

"brodiemac" wrote in message
...
Very close and thank you for the suggestion. I'm not looking for a
dropdown
in the second cell. I want the second cell to auto-populate with data
associated with what was selected in the drop down in the first cell.

"JulieD" wrote:

Hi

maybe this is what you're looking for
http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

"brodiemac" wrote in message
...
I'm creating a new sheet to assign shifts for my employees. I want to
have a
drop down in one cell where I can pick shift times then in the next
cell,
have the hours automatically picked in assiciation with the shift.
I've
already created the drop down using validation but am not sure how to
get
the
second cell to automatically picks the hours associated with the shift.
Is
this a vlookup function or other?

OK, I tried that and I keep getting #N/A. Here's what I have

........R.................S.......................
1....SHIFT...........HOURS................
2....8-5...............8.....................
3....7-5...............9.....................

My drop down is in cell B4 and uses validation from the above lists.

formula:

=vlookup(B4,$R$2:$S$10,2,TRUE)

All it will give me is a #N/A error.

"JulieD" wrote:

Hi

then you can use the VLOOKUP function

assuming you have a table somewhere (maybe sheet 2) with
...........A..................B................... ......C
1.....Shift...............Start Time............End Time
2.....AM..............06:00....................... .18:00

etc
then with your drop down on sheet 1 cell A1
click in B1 (or where you want the start time returned to) and type
=VLOOKUP(A1,Sheet2!$A$2:$C$10,2,0)
for the end time it would be
=VLOOKUP(A1,Sheet2!$A$2:$C$10,3,0)

hope this helps
Cheers
JulieD

"brodiemac" wrote in message
...
Very close and thank you for the suggestion. I'm not looking for a
dropdown
in the second cell. I want the second cell to auto-populate with data
associated with what was selected in the drop down in the first cell.

"JulieD" wrote:

Hi

maybe this is what you're looking for
http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

"brodiemac" wrote in message
...
I'm creating a new sheet to assign shifts for my employees. I want to
have a
drop down in one cell where I can pick shift times then in the next
cell,
have the hours automatically picked in assiciation with the shift.
I've
already created the drop down using validation but am not sure how to
get
the
second cell to automatically picks the hours associated with the shift.
Is
this a vlookup function or other?

Oops, type. Formula actually looks like this:

=vlookup(B4,$R$2:$S$10,19,TRUE)

"brodiemac" wrote:

OK, I tried that and I keep getting #N/A. Here's what I have

.......R.................S.......................
1....SHIFT...........HOURS................
2....8-5...............8.....................
3....7-5...............9.....................

My drop down is in cell B4 and uses validation from the above lists.

formula:

=vlookup(B4,$R$2:$S$10,2,TRUE)

All it will give me is a #N/A error.

"JulieD" wrote:

Hi

then you can use the VLOOKUP function

assuming you have a table somewhere (maybe sheet 2) with
...........A..................B................... ......C
1.....Shift...............Start Time............End Time
2.....AM..............06:00....................... .18:00

etc
then with your drop down on sheet 1 cell A1
click in B1 (or where you want the start time returned to) and type
=VLOOKUP(A1,Sheet2!$A$2:$C$10,2,0)
for the end time it would be
=VLOOKUP(A1,Sheet2!$A$2:$C$10,3,0)

hope this helps
Cheers
JulieD

"brodiemac" wrote in message
...
Very close and thank you for the suggestion. I'm not looking for a
dropdown
in the second cell. I want the second cell to auto-populate with data
associated with what was selected in the drop down in the first cell.

"JulieD" wrote:

Hi

maybe this is what you're looking for
http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

"brodiemac" wrote in message
...
I'm creating a new sheet to assign shifts for my employees. I want to
have a
drop down in one cell where I can pick shift times then in the next
cell,
have the hours automatically picked in assiciation with the shift.
I've
already created the drop down using validation but am not sure how to
get
the
second cell to automatically picks the hours associated with the shift.
Is
this a vlookup function or other?

Brodie ...

Your formula ... =vlookup(B4,$R$2:$S$10,19,TRUE)

With Range ($R$2:$S$10) ... you only have 2 Cols ... but
your vlookup formula is calling for the 19th Col of the
Range ($R$2:$S$10)... can't be ...

Also ... I love vlookup, but for my applications I tend to
set TRUE to FALSE (or "0") ... Kha

-----Original Message-----
Oops, type. Formula actually looks like this:

=vlookup(B4,$R$2:$S$10,19,TRUE)

"brodiemac" wrote:

OK, I tried that and I keep getting #N/A. Here's what
I have

.......R.................S.......................
1....SHIFT...........HOURS................
2....8-5...............8.....................
3....7-5...............9.....................

My drop down is in cell B4 and uses validation from the
above lists.

formula:

=vlookup(B4,$R$2:$S$10,2,TRUE)

All it will give me is a #N/A error.

"JulieD" wrote:

Hi

then you can use the VLOOKUP function

assuming you have a table somewhere (maybe sheet 2)
with

...........A..................B................... ......C
1.....Shift...............Start Time............End
Time

2.....AM..............06:00....................... .18:00

etc
then with your drop down on sheet 1 cell A1
click in B1 (or where you want the start time
returned to) and type
=VLOOKUP(A1,Sheet2!$A$2:$C$10,2,0)
for the end time it would be
=VLOOKUP(A1,Sheet2!$A$2:$C$10,3,0)

hope this helps
Cheers
JulieD

"brodiemac"
wrote in message
news:6BAEE7C2-852E-47A9-B44F-
...
Very close and thank you for the suggestion. I'm
not looking for a
dropdown
in the second cell. I want the second cell to auto-
populate with data
associated with what was selected in the drop down
in the first cell.

"JulieD" wrote:

Hi

maybe this is what you're looking for
http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

"brodiemac"
wrote in message
news:1278F06F-E41F-4152-AEE6-
...
I'm creating a new sheet to assign shifts for my
employees. I want to
have a
drop down in one cell where I can pick shift
times then in the next
cell,
have the hours automatically picked in
assiciation with the shift.
I've
already created the drop down using validation
but am not sure how to
get
the
second cell to automatically picks the hours
associated with the shift.
Is
this a vlookup function or other?






.

Yours might be a problem with cell formatting. You could try formatting all
the cells referenced in your vlookup as text and re-entering the
information. This worked for me when I tried to replicate your problem.
Changing the Range_lookup in your formula from TRUE to FALSE might be an
easier way, since your drop-down list draws from your table's list anyway.

Jim
"brodiemac" wrote in message
...
Oops, type. Formula actually looks like this:

=vlookup(B4,$R$2:$S$10,19,TRUE)

"brodiemac" wrote:

OK, I tried that and I keep getting #N/A. Here's what I have

.......R.................S.......................
1....SHIFT...........HOURS................
2....8-5...............8.....................
3....7-5...............9.....................

My drop down is in cell B4 and uses validation from the above lists.

formula:

=vlookup(B4,$R$2:$S$10,2,TRUE)

All it will give me is a #N/A error.

"JulieD" wrote:

Hi

then you can use the VLOOKUP function

assuming you have a table somewhere (maybe sheet 2) with
...........A..................B................... ......C
1.....Shift...............Start Time............End Time
2.....AM..............06:00....................... .18:00

etc
then with your drop down on sheet 1 cell A1
click in B1 (or where you want the start time returned to) and type
=VLOOKUP(A1,Sheet2!$A$2:$C$10,2,0)
for the end time it would be
=VLOOKUP(A1,Sheet2!$A$2:$C$10,3,0)

hope this helps
Cheers
JulieD

"brodiemac" wrote in message
...
Very close and thank you for the suggestion. I'm not looking for a
dropdown
in the second cell. I want the second cell to auto-populate with
data
associated with what was selected in the drop down in the first
cell.

"JulieD" wrote:

Hi

maybe this is what you're looking for
http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

"brodiemac" wrote in message
...
I'm creating a new sheet to assign shifts for my employees. I
want to
have a
drop down in one cell where I can pick shift times then in the
next
cell,
have the hours automatically picked in assiciation with the
shift.
I've
already created the drop down using validation but am not sure
how to
get
the
second cell to automatically picks the hours associated with the
shift.
Is
this a vlookup function or other?