Hello - First post here!
I need help with a formula please. Example attached.
I have a Unique Identifier in Spreadsheet.1, and I'm trying to find a Metric in Spreadsheet.2 that begins with a certain value, that is associated with that Unique Identifier. If the value is found, then I would like the formula to return the Metric ID in spreadsheet.2 (that is associated with that Metric and that Unique Identifier), into spreadsheet.1. If the value is not found, then it should just return "Not Found". Metrics Example_1_HRIS_6.1.2015.xlsx
I need to do this for (6) different metrics:
"Q1 -"
"Year to Date"
"Pipeline"
"Marketing"
"Sales"
"DSM"
The purpose is to update existing metrics with current data, based on the Metric ID. I need the correct Metric ID, for that Unique Identifier and Metric, in order to update our system.
Please see attachment for example. Let me know if any additional info is needed. Thanks for taking the time to review!
Bookmarks