Hi!
Hi! Hope the title was not all too unclear! I have stumbled upon a problem which I have not been able to solve, I have tried different approaches such as index, match, if- formulas but to no avail. I have a workbook with several tabs that all represent a city each, within the tabs there is projects lined up with each column representing different information such as company, category, size. To the right of the information above there is a "field" where color represent when the project start and some other things. What I am looking for is a form on a new tab or workbook that looks something like this
City(which tab)=
Project size=
Project start=
So it could look something like this
City(tab)=New York
Project size(Column 4)=110
Project start(represented by green square)=Q3 19
And what I am looking for is for it to return all the rows that meet the above criteria. I will include access to an example workbook.
Would be very grateful if someone has time to take a look!
Kind regards Bruien
Hi! Hope the title was not all too unclear! I have stumbled upon a problem which I have not been able to solve, I have tried different approaches such as index, match, if- formulas but to no avail. I have a workbook with several tabs that all represent a city each, within the tabs there is projects lined up with each column representing different information such as company, category, size. To the right of the information above there is a "field" where color represent when the project start and some other things. What I am looking for is a form on a new tab or workbook that looks something like this
City(which tab)=
Project size=
Project start=
So it could look something like this
City(tab)=New York
Project size(Column 4)=110
Project start(represented by green square)=Q3 19
And what I am looking for is for it to return all the rows that meet the above criteria. I will include access to an example workbook.
Would be very grateful if someone has time to take a look!
Kind regards Bruien