Having trouble creating auto filling cells based off a list

[FaceLifter]

I am trying to create a sheet that references information off of another sheet.

I have sheetA that with a list of first names, last names, scheduled hours, and worked hours.

On sheetB I have created a drop-down list of the first names on sheetA by using validity>cell ranges.

What I am now trying to do is have the next column in sheetB automatically fill in the last name from sheetA, once the first name is chosen.

Then about 3 cells over I want to automatically fill in the scheduled hours based off of the first name chosen, but I attempted this yet.

I hope that explains it.

I've tried to create multiple IF statements since there are only 34 rows. But I couldn't get more than one IF statement to work.

=IF(B12=$sheetA.B11;$sheetA.C11);IF(B12=$sheetA.B12;$sheetA.C12)

I've also tried VLOOKUP, but I'm not sure how to get it to work.

[corona]

Hehe, that's funny, i've just got a great reply to basically the same question, here: http://www.oooforum.org/forum/viewtopic.phtml?t=76511
Maybe this is an often asked question, although nothing I tried searching for brought it up.

Good Luck!
Andrew

[rajaiskandarshah]

you need to use the =vlookup function

here is a similar example:
http://www.oooforum.org/forum/viewtopic.phtml?t=76576

you can probably get a better understanding in my blog post
http://software.krimnet.com/open-source/how-lookup-city-and-state-based-zipcode.htm


_________________
http://rajaiskandarshah.blogspot.com
http://software.krimnet.com/blogs/rajaiskandarshah