Automatic data entery

Hi, I'm creating a spread sheet with some drop down lists to make it a bit easier (and more fool proof) to fill out a man power cost tracking sheet. In one column I am putting the pa levels using "Data" "valadaition" to crate the drop downs but what I was hoping to do was to have the sheet automaticly fill in the rate for that choosen pay level in a adjacent cell. Is there a way to do this? I'll include a picture if it helps.

Ex.jpg

You would normally use VLOOKUP to do this. Set up a table somewhere which has your levels in one column and the appropriate rates in the column next to it on the right (you probably already have the levels listed somewhere to supply your data validation, so just use the column next to this - assume it is in columns L and M). Then you can use the formula:

=VLOOKUP(A2,$L:$M,2,0)

where I have assumed A2 contains the data validation cell, as it is not clear from your picture (a workbook is more useful as an attachment).

Hope this helps.

Pete

So if your data validation list is in A1 then:

=if($A$1="Level I",400.00,if($A$1="Level II",300.00,if($A$1="Level III",200.00)))

And so forth and so forth.

Originally Posted by FDibbins

it would make it far easier for us to help you i you uploaded a sample workbook, rather than just a picture

Oh, sorry about that. I'll atach an example of what I'm working on here.

I'll give some of the suggestions a try and see if I can get it set up properly.

Example.xls

There you go, nice and simple.

pl see attached file.