Hello All,
I have a vlookup formula (looking Project ID) to produce a report from a pivot table. The report have 12 columns (YY-MM format) and the values will be zero if not found in the pivot so everything works when the pivot shows all 12 columns.
The problem start when the pivot does not show all columns, for example is there is no data for "20-01" then the pivot will remove that column and the report will show incorrect numbers on some columns.
Attached is a sample of the situation. Is there is a formula to use in the report where I can get the value looking for "Project ID", but also by the column title (example "19-11") in the pivot?
Thank you.
Bookmarks