Hi - I'm close but not there.. please help
The workbook contains a summary sheet with different criteria’s listed in a column.
A different sheet where the data entry should be have a set of criteria’s listed in column A with 12 Months in the other columns
User enters data per month. Only data for the current month should show up on the summary sheet.
How can I get my formula straight so I dont get the #N/A. All month work but April. Also is there a formula combination between the index/match and vlookup? as I have 200 metrics in data entry sheets and only selected in summary - would cut down on formula writing - any help is super appreciated - thanks in advance - attached sample of concept
Bookmarks