Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP not returning results | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |