# Thread: Formula help based on two criterai

1. ## Formula help based on two criterai

Hi Loungers

I'm after some help to develop a formula that will return a value based on a name and month and return a value.

I think the attached will show what I'm trying to achieve - need to look at the date in the Worksheet and return the values in the Lead indicators worksheet.

B7 in the Lead indicator worksheet for M004 should return a value of 4265 for May-13; 4122 for June-13 etc, and M005 3311 for May-13 etc

I hope that makes sense

Any help would be much appreciated

The spreadsheet is generated from a database so will have numerous project, values etc

2. Do you mean:

=LOOKUP(2,1/(Worksheet!\$C\$10:\$C\$22=\$A7)/(Worksheet!\$B\$10:\$B\$22=B\$6),Worksheet!\$R\$10:\$R\$22)

3. Thanks Rory - yep that works just right.

Thanks for your help

Regards

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•