V
vinu
Hi,
I’m trying to insert a user friendly sheet where they can enter there
“Area” “Place” and which “shift time” they will be coming to find what
time the vehicle will come to there Place to pick them.
All the details are there in the next sheet as a table with heading
like, Area-Place7.30-8.30-…-19.30-(shift times)
For area, Place & Shift time I used data validation so that they can
select them from drop down but I don’t know how to pull the pickup
time that will match to 3 other cells..
Should I use the Hlookup to get the data that will be under the
particular shift time, if that is the case thaen how can I match the
shift time with Area & Place..
I may sound confused coz I’m really confused…!!
Pls help me on this…….
Regards,
Vinu
I’m trying to insert a user friendly sheet where they can enter there
“Area” “Place” and which “shift time” they will be coming to find what
time the vehicle will come to there Place to pick them.
All the details are there in the next sheet as a table with heading
like, Area-Place7.30-8.30-…-19.30-(shift times)
For area, Place & Shift time I used data validation so that they can
select them from drop down but I don’t know how to pull the pickup
time that will match to 3 other cells..
Should I use the Hlookup to get the data that will be under the
particular shift time, if that is the case thaen how can I match the
shift time with Area & Place..
I may sound confused coz I’m really confused…!!
Pls help me on this…….
Regards,
Vinu