Formula to return text that corresponds to a MAX formula done in a different column

Hello,

I am trying to do the following:

I am doing some string comparison work.

So, in columns A-E I am comparing strings to a value in Col F.

The rows go to about 1000.

Each row in Column F has a piece of text that I am trying to compare to its corresponding columns in that particular row.

Example:

A1: Appleby,
B1: Oranges,
C1: Grapes,
D1: Bananas,
E1: Apricots,

F1: Apples

A2: Up
B2: Downy
C2: Right
D2: Left
E2: Over

F2: Down

I have a comparison formula that I've written as a UDF in Columns K through O that gives the % similarity between the strings in Columns A-E to the value in Column F, by row.

Example: (Keep in mind, these are going ACROSS in the actual spreadsheet, not down as I have to write it below.)

K1 = CompareString($F1,A1) = 60%
L1 = CompareString($F1,B1) = 0%
M1 = CompareString($F1,C1) = 0%
N1 = CompareString($F1,D1) = 0%
O1 = CompareString($F1,E1) = 0%

K2 = CompareString($F2,A2) = 0%
L2 = CompareString($F2,A2) = 67%
M2 = CompareString($F2,A2) = 0%
N2 = CompareString($F2,A2) = 0%
O2 = CompareString($F2,A2) = 0%

(as I mentioned, this goes on to row 1000)

If I do a MAX formula in Column P, I get 60% in P1, and 67% in P2.

If I use a =cell("address",(Index(...,Match(Max...)))) formula, I get K1 and L2.


WHAT I NEED:

What I need is a formula that Returns the TEXT that corresponds to the 60% and 67%.

So, I need formula to put in Column Q or Column R that returns the following:

R1 = Appleby
R2 = Downy

Does that make sense?

Also, I cannot use "ctrl+shift+enter" for these.

Thanks,

rjw524