Adding multiple columns for drop down list

Hi everyone,

I'm trying to set up a billing form for my work. I'm trying to include drop down list for each sections (personnel, equipment, and supplies), then all sum together as a bill. I'm not sure if this is doable in excel. Can someone please help?

Thanks in advance

Hi, could you explain in a little more detail what you need? Your description is a bit brief so it's hard to provide you with a solution.

S.

Originally Posted by natalien03

Hi Spencer,

What I wanted to do is that if say I do a validation list base on personnel description, the rate should automatically fill in for the next column, so I can multiply that rate with the quantity to get a total. I hope this makes some sense.

Set up your data validation as you mention and then elsewhere in the workbook set up a small lookup table with the data validation values in the first column and the relevant rate for each in the next column. Then use VLOOKUP to feed in the rate as each value is selected from the validation list.

Does that make sense?

I may have missed the point completely. Perhaps a manually created before and after version of the workbook would help.

=IFERROR(Your Formula Here,"")

Not a problem. Happy to help.

S.