Help for Obtaining a Formula by INDEX, MATCH and IF LOOK UP values

**santhoshie** · 08-26-2011, 06:31 AM

Hi all,

I am looking to obtain a formula in a cell n Project Quota sheet by Matching the values in 'Project Quota' Sheet with 'Estimate Amounts' Sheet If the match is true then the value should come from 'Estimate Amounts' Sheet.

If you can look into the attached file then probably you should be able to understand I have added comments in there so please look in to the Project Quota sheet for the commments.

Thanks

**NBVC** · 08-26-2011, 08:46 AM

Here is my best guess at your question:

This formula in D4:

Please Login or Register  to view this content.

copied down, then select the D14:D19 range and copy to all the other red ranges.

This formula looks at all the upper blue cells in the top 2 tables of the source sheet, and the next wider blue cells below and matches them to the project headers in Row 2 of Sheet2 and the Activities in column A of Sheet2, respectively, then sums up the matches of the Actual Hours (either under the peach cells in upper table or next to peach cells in second table).