Hello, and thanks for taking time to help.

This is student testing data. Every column is a different question with a different correct answer, which is marked with a + in the cell. I need to find the correct answer from the range and return it in a different cell at the top of the column. The trickiness for me is that I never know where the correct answer will be found in the range, otherwise I could keep the simple if formula that is in there now.

I'd prefer to do it with a formula I think, as this is part of a template that many different people will use, who all have different data.

Hopefully the attached image or file helps to see what I mean.

sample.jpg

find and return sample.xlsx