Conditional Formula from multiple data tables
Hi,
Please help on the conditional formula from the multiple tables data as per enclosed file.
I have a two data tables i.e. A2:C13 and I2:P13
I2:P13 is Basic reference data table (fixed data)
A2:C13 is Variable data table (it can be changed as per requirement)
Result to be required from E2:F8 table from the above two tables.
Example reference is shown in G3 to G5 cells.
Hi roven.
What value should go in F3? I don't see how you would get 559. Is that the value that goes into F3 or do you want some conditional format in cell F3?
I guess I don't understand the question. Sorry
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Try in F3:
Fill down
Please Login or Register to view this content.
Quang PT
Hi,
Thanks for quick response. My query is..
Need formula in F3 to F8 cells with the condition of
In cell F3
If the row data "K2:P2" matches with E3 then related column data to be multiplied with the related column "C3:C13" by matching the two columns "I3:I13" and "A3:A13" data range.
Complete answer will be like this
Activity Req. days
Resource-1 559
Resource-2 544.2
Resource-3 1872.5
Resource-4 2987.42
Resource-5 4131.8
Resource-6 996.95
Dear Bebo,
Thanks for your reply. I got the answer what I need.
Thank you very much
Can you please match the Activity Criteria i.e. Range "A3:A13" and "I3:I13" because if the both tables are different size then answer will be matched as per the available activities only and the remaining will be zero.
Last edited by roven.aravind; 02-17-2020 at 03:38 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks