I'm using this formula:
=IF(A3=A2,
pull(CONCATENATE("'F:\ITO\",A3," Project","\", "[",A3,".xlsx]Server Config'!","A5")),
pull(CONCATENATE("'F:\ITO\",A3," Project","\","[",A3,".xlsx]Server Config'!","A4")))
Where Column A contains the project number. Not all project have the same number of lineas, and every time the project change it have to restart counting for A4.
How can I do to say this formula, or another that if the number of the project is the same that the previous row, continue counting with A5, A6..... till the time the project number will change, in this case it has to start again with A4?
The structure of this table is the follow:
A2 = "Project Number"
B2 = =pull(CONCATENATE("'F:\ITO\",A2," Project","\","[",A2,".xlsx]Server Config'!","A4"))
A3 = "Project Number"
B3 = =IF(A3=A2,pull(CONCATENATE("'F:\ITO\",A3," Project","\","[",A3,".xlsx]Server Config'!","A5")),pull(CONCATENATE("'F:\ITO\",A3," Project","\","[",A3,".xlsx]Server Config'!","A4")))
Every project is the reference to one file, and every file contains different information in the same cells.