excuse my excel noobness
i want to automate some processes and do this ->
have some drop down selection boxes that would have the following
Fulltime
Partime
Fulltime Sat
(and some others)
know how to set up the validation for this but ->
when someone selects say "Fulltime" the cell next it then puts in the appropriate rate from my data source
so if they choose "Fulltime" the next cell populates with a dollar value

been tooling around for a while but it's doing my head in, tried, if, vlookup, hlookup, but am really struggling with understanding it.
all help appreciated

cheers

=IF(C14
where F1:G4 in this example have the data table (f has the letters, G has the values)

I don't have office installed on this PC so I can't really give you exactly what you're after, but play with this for now and I'll get back to you

can't even edit that post,
http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/

chers teq i'll try some of that

or a vlookup

=VLOOKUP([value you want to look up, e.g fulltime, blah],[table of data with the lookupvalue in the first column],[column of data to return value from],[FALSE cause thats what I always use])

say you have the dropdown in A1 and you have a table of data in say D1:E4 (D has the name of the position, E has the dollar amount

in Cell B1 use
=vlookup(A1,D1:E4,2,FALSE)

Function-based logic code is fun times. IF(AND(a,OR(b,c))) bracket hell!

To do this I had the drop down box return a number, in your case say 1 for full time, 2 for part time etc etc. I'm pretty sure you can return the number to a cell of your choosing. I would hide the number in the cell where the drop down box was.

After you have this number, you just need to do a vlookup next to the drop down box using the number.

eg Say you have a drop down box covering B2, and the result of the box hiding under it also in B2. You have your data in a small table from F2:H3

in cell B3 ---> =vlookup(B2,F2:H3,2)

I hope this makes some sense, it's been over 5 years since i used excel :)

first post in a help thread?

google loves the qgl community <3

Lurked long time

thx uber
i lived in gladstone for 5 years.....

i was bored so..

Book1.xls

I'd still go with vlookups. Then when someone wants all the data changed you just say give me it in a certain format and cut and paste it in.

http://rs114.rapidshare.com/files/302718593/employee-type.xls

last edited by shad at 23:33:56 05/Nov/09

Epic that spreadsheet was AIDS

what shad said, but who needs dropdowns ? auto complete is the win.

Only time I wouldn't do that is if this is wasn't a historical document ie. where what they got paid wasn't important in the future.

If it was I'd probably look at a custom macro/function

thanks shad that's what i needed. cleared it up in my head.

obes can you elaborate?
it's for a quoting template so it's not a historical doc as such. will use a new one each quote.
plus i will extend the parameters to pick up other costs by using vlookup.
so whats the diff between this and what you suggest?

Geez QGL rocks :)