Hi
I’m trying to provide an outcome based on data entered in Cell H1 of the “01 Clients Units by year” sheet that then references to individual client sheets providing the result outcome in the appropriate year.
The formula should identify both the year and unit in the client sheet, and if both the unit and year are populated in the sheet, then the result is duplicated in the appropriate year of the “ 01 Clients Units by year” sheet.
The text in Cell H1 is changeable, so at any given time the formula will always reference to H1, and provide results according to the unit code typed in H1.
The desired outcome is represented in the “01 Clients Units by year” sheet.
Formula added, issues with Vlookup in Row C, works with hard key full name, but not with Vlookup in the Full Name Column C.
I have reloaded the test file with the formula supplied and the Vlookup added in column C.
Bookmarks