Trying to find value text

Shirley Vue

I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range 2}"Q1_2020" @cell, "Q2_2020" @cell, "Q3_2020" @cell, "Q4_2020" @cell, false)" What I'm looking for is to find the triggering quarter of each product when the issue occurred. Please let me know what I did wrong here. Thank you.

Paul Newcome

Are you able to provide a screenshot of the source and target sheets with sensitive/confidential data removed, blocked, or replaced with "dummy data" as needed?

Shirley Vue

Paul Newcome

What about the source sheet? I am having trouble following exactly what you are trying to accomplish.

Shirley Vue

Sorry, there are way too many sensitive data for me to show but I think I figured it out by creating a metrics grid and put in a manual column and count quantity issues instead. Thank you.

Paul Newcome

Sure thing.

A lot of metrics can be automated, but it was just hard to tell exactly what data you were wanting to pull based on your description and formula provided.

Based on your use of the VLOOKUP, I would assume you are wanting to pull a single specific data point, but I don't quite understand your specific "text to search for" listed.

You can pull the Q1, Q2, etc value based on the data in the Program column, but your formula would need to be set up differently.