Hi there,
I am developing a Master Project Tracking workbook for an architectural firm which will pull data from other workbooks and summarize them.
The first task I have to figure out is as follows:
If we have a Project titled Kim's House in Column B (Project Name) in the Master Project Tracking workbook, the formula will look for Kim's House in Column B (Project Name) of the Permit Tracking Workbook and if column N (Issued) is Yes in the Permit Tracking Workbook then it enters a Yes in column I (Permit Status) of the Master Project Tracking workbook.
If Not Yes (values such as blanks, No) in the Permit Tracking Workbook, then it enters a No in the Master Project Tracking workbook.
I am guessing this is some combination of an IF query and a Match and an AND, but it's beyond my skill level.
Thanks in advance! Happy to clarify if needed.
I am developing a Master Project Tracking workbook for an architectural firm which will pull data from other workbooks and summarize them.
The first task I have to figure out is as follows:
If we have a Project titled Kim's House in Column B (Project Name) in the Master Project Tracking workbook, the formula will look for Kim's House in Column B (Project Name) of the Permit Tracking Workbook and if column N (Issued) is Yes in the Permit Tracking Workbook then it enters a Yes in column I (Permit Status) of the Master Project Tracking workbook.
If Not Yes (values such as blanks, No) in the Permit Tracking Workbook, then it enters a No in the Master Project Tracking workbook.
I am guessing this is some combination of an IF query and a Match and an AND, but it's beyond my skill level.
Thanks in advance! Happy to clarify if needed.
