Help With Drop Down Boxes
 

Hi I have a question for someone who hopefully got an answer lol... Im making
a spreadsheet for billing for my company I work for (We contract for
Comcast). We have codes for each job performed... Now on sheet2 of my
project I have made a column for "Codes", a column for "Code Descriptions", a
column for "Total Cost", and a column for "Total Miles" and filled each cell
in accordingly with the data I need.... What Im trying to do is on sheet1,
create a drop down box with the "Codes" in it... Now I know how to make a
drop list with the "Codes" but how can I get it to fill in the information
(Code Description, Total Cost, Total Miles) into the corresponding columns
automatically when I click on a code out of the drop list? I do not want to
have to manually select each code, each code description, each total cost,
and each total mileage each time I select a code because it kind of defeats
the purpose for my boss... Is there any forumlas or any functions or ANYTHING
I can do to have this happen lol??? Thank you for your time!

PS- I have not used Excel since high school soooo its been awhile! Thank you!

Help With Drop Down Boxes
 

VLOOKUP, live it, learn it, love it

Example: on your sheet2, assuming Codes is in column A, Code Description in
column B, Total Cost in column C, Total Miles in Column D. Also assuming that
the list of codes you create is based on column A (this means there will
always be a match).
Assuming on sheet 1, your drop down box is in A2
to get Code Description
B2: =IF(A2="","",VLOOKUP(A2,Sheet2!$A$2:$D$100,2,FALSE ))
to get Total Cost
C2: =IF(A2="","",VLOOKUP(A2,Sheet2!$A$2:$D$100,3,FALSE ))
to get Total Miles
D2: =IF(A2="","",VLOOKUP(A2,Sheet2!$A$2:$D$100,4,FALSE ))

Obviously the range on sheet 2, adjust accordingly

Hope this helps.
--
John C


"ChazFr" wrote:

Hi I have a question for someone who hopefully got an answer lol... Im making
a spreadsheet for billing for my company I work for (We contract for
Comcast). We have codes for each job performed... Now on sheet2 of my
project I have made a column for "Codes", a column for "Code Descriptions", a
column for "Total Cost", and a column for "Total Miles" and filled each cell
in accordingly with the data I need.... What Im trying to do is on sheet1,
create a drop down box with the "Codes" in it... Now I know how to make a
drop list with the "Codes" but how can I get it to fill in the information
(Code Description, Total Cost, Total Miles) into the corresponding columns
automatically when I click on a code out of the drop list? I do not want to
have to manually select each code, each code description, each total cost,
and each total mileage each time I select a code because it kind of defeats
the purpose for my boss... Is there any forumlas or any functions or ANYTHING
I can do to have this happen lol??? Thank you for your time!

PS- I have not used Excel since high school soooo its been awhile! Thank you!

Help With Drop Down Boxes
 

Thanks a lot man that REALLY REALLY helped me alot... Im just trying to make
his billing easier for him. Great job friend!

"John C" wrote:

VLOOKUP, live it, learn it, love it

Example: on your sheet2, assuming Codes is in column A, Code Description in
column B, Total Cost in column C, Total Miles in Column D. Also assuming that
the list of codes you create is based on column A (this means there will
always be a match).
Assuming on sheet 1, your drop down box is in A2
to get Code Description
B2: =IF(A2="","",VLOOKUP(A2,Sheet2!$A$2:$D$100,2,FALSE ))
to get Total Cost
C2: =IF(A2="","",VLOOKUP(A2,Sheet2!$A$2:$D$100,3,FALSE ))
to get Total Miles
D2: =IF(A2="","",VLOOKUP(A2,Sheet2!$A$2:$D$100,4,FALSE ))

Obviously the range on sheet 2, adjust accordingly

Hope this helps.
--
John C


"ChazFr" wrote:

Hi I have a question for someone who hopefully got an answer lol... Im making
a spreadsheet for billing for my company I work for (We contract for
Comcast). We have codes for each job performed... Now on sheet2 of my
project I have made a column for "Codes", a column for "Code Descriptions", a
column for "Total Cost", and a column for "Total Miles" and filled each cell
in accordingly with the data I need.... What Im trying to do is on sheet1,
create a drop down box with the "Codes" in it... Now I know how to make a
drop list with the "Codes" but how can I get it to fill in the information
(Code Description, Total Cost, Total Miles) into the corresponding columns
automatically when I click on a code out of the drop list? I do not want to
have to manually select each code, each code description, each total cost,
and each total mileage each time I select a code because it kind of defeats
the purpose for my boss... Is there any forumlas or any functions or ANYTHING
I can do to have this happen lol??? Thank you for your time!

PS- I have not used Excel since high school soooo its been awhile! Thank you!

Help With Drop Down Boxes
 

Thanks for the feedback :)
--
John C


"ChazFr" wrote:

Thanks a lot man that REALLY REALLY helped me alot... Im just trying to make
his billing easier for him. Great job friend!

"John C" wrote:

VLOOKUP, live it, learn it, love it

Example: on your sheet2, assuming Codes is in column A, Code Description in
column B, Total Cost in column C, Total Miles in Column D. Also assuming that
the list of codes you create is based on column A (this means there will
always be a match).
Assuming on sheet 1, your drop down box is in A2
to get Code Description
B2: =IF(A2="","",VLOOKUP(A2,Sheet2!$A$2:$D$100,2,FALSE ))
to get Total Cost
C2: =IF(A2="","",VLOOKUP(A2,Sheet2!$A$2:$D$100,3,FALSE ))
to get Total Miles
D2: =IF(A2="","",VLOOKUP(A2,Sheet2!$A$2:$D$100,4,FALSE ))

Obviously the range on sheet 2, adjust accordingly

Hope this helps.
--
John C


"ChazFr" wrote:

Hi I have a question for someone who hopefully got an answer lol... Im making
a spreadsheet for billing for my company I work for (We contract for
Comcast). We have codes for each job performed... Now on sheet2 of my
project I have made a column for "Codes", a column for "Code Descriptions", a
column for "Total Cost", and a column for "Total Miles" and filled each cell
in accordingly with the data I need.... What Im trying to do is on sheet1,
create a drop down box with the "Codes" in it... Now I know how to make a
drop list with the "Codes" but how can I get it to fill in the information
(Code Description, Total Cost, Total Miles) into the corresponding columns
automatically when I click on a code out of the drop list? I do not want to
have to manually select each code, each code description, each total cost,
and each total mileage each time I select a code because it kind of defeats
the purpose for my boss... Is there any forumlas or any functions or ANYTHING
I can do to have this happen lol??? Thank you for your time!

PS- I have not used Excel since high school soooo its been awhile! Thank you!