Urgent: Help Required with Lookups

Hi guys.

I require some urgent help with the following excel. Have to complete this in the next 2-4 hours.

Please help! Attached the XLS file in the attachment.

Thanks a lot in advance.

You are new here. BUT there is so much wrong here.

1. No-one in their right mind will post their email address on a public forum, unless they really love spam.

2. It may be urgent to you, but we are volunteers, offering our time freely... not your employees or you personal slaves.

3. Change your thread title to something meaningful. what would you use as a search term in Google?

4. Post a SAMPLE sheet (10-20 rows) illustrating your problem and showing manually calculated expected results.

5. Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Are you REALLY trying to tell me that you would have used "Urgent: Help Required with Lookups" as a Google search term???

Think again and provide a sensible title.

Also, to repeat: we are not your slaves and do not care how urgent YOU think the problem is.

NO HELP to be offered to the OP until a further sensible title is provided.

Where are the manually calculated answers that you were asked for?