If, And, isText? How best to construct my formulas to get desired result?

Thank god for forums like these!

I'm not completely new to Excel but I just can't seem to wrap my head around how best to work with formulas to achieve the desired result. I've spent a good deal of my day trying to figure it out /wince.

I have attached files for better understanding.


Capture.JPGCapture2.JPG


I have a sheet that breaks down weekly jobs by day, the amount collected and also some drop down selection boxes to pick a contractor and enter how much they were paid for their services.

My goal is to have a payout sheet that will take data as it is entered into the weekly tracker and organize it so it so the output automatically shows how much each individual contractor is paid per week.

I tried some: =IF(AND() but I think i'm doing it wrong. I want the payout sheet to do this in plain english:

Go to cell B3, If there is no text or number, display nothing. IF there IS a data/number/text then check the data range of names (a5:a11) if the name is "Victor", display the data on the same row in column B (cell b5). If it could auto populate the name of the customer that would be great too but i think that will need to be just a Istext statement on its own.

I have no clue if this is the optimal way to get the desired result. I respect everyone who helps as it's above me lol!

Here is a sample attachment

Really? It's office 2010 workbook. could that be the reason?Attachment 26121507.13 Weekly Tracker2.xls

here is a older 2003 version.

I uploaded a new file. The payroll tab has just plain data entered as an example of what I would like to populate automatically from the other. If anyone knows a better way to achieve this, please do tell.