# Thread: Help with formula

1. ## Help with formula

Hi Loungers,

After some help (again)

Trying to sort out a formula in C35 that matches the date in A33 along Row 2 and then the project name in B35 on.

The result should return the value of 9408 for Feb 13 and Project 1, with the value changing when the date in C35 changes.

I tried to get this to work in the formula in F35, but I've got something wrong.

I hope that makes sence

Any assistance woudl be approciated

2. Try this for Project 1, then fill down:

=INDEX(\$B\$2:\$AL\$25,MATCH(B35,\$B\$2:\$B\$25,0),MATCH(\$ A\$33,\$B\$2:\$AL\$2,0))

I believe in your example you had the row/column index reversed.
And, you need to look just at the project column for one match and just at the date row for the other.

Alternatively:

=VLOOKUP(B35,\$B\$2:\$AL\$25,MATCH(\$A\$33,\$B\$2:\$AL\$2,0) ,FALSE)

3. Thanks for your help - that looks to do the job just right.

Regards

4. Verada,

This formula: =OFFSET(\$B\$2,MATCH(\$B35,\$B\$3:\$B\$24,0),MATCH(\$A\$33, \$C\$2:\$AL\$2,0))
Placed in cell C35 can then be filled down to do the trick. Please note that the sample worksheet had Feb 13 as the date but the number in your OP was for January and you have the dates restricted. HTH
VeradaFormula.JPG

5. It's really fun to see three solutions to one problem. Flexibility!! Options!!

6. Thanks to all for your help - very much appreciated

There seems to always be more than one way to skin a cat!

Regards

Verada

#### Posting Permissions

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