Values are as follows:
Cell A1 is a calculated value between 1 and 26. In this case, it equals 19
Cell A2 is the letter "J"
In Row 19, Columns A through Z, I have one letter of the alphabet in each cell, in sequence, BUT I'm starting with the letter "S".
So, A19="S", B19="T" ...Y19="Q", Z19="R"
Here's what I'm trying to accomplish:
I want a formula to determine the intersecting column for the value in A2 in the row specified in A1.
MATCH(A2,$A$19:$Z$19) will work; however, I need to calculate the lookup_array value.
=CONCATENATE(ADDRESS(A1,1),":",ADDRESS(A1,26)) will produce the correct lookup array value, BUT...
Unfortunately, when I imbed the CONCATENATE function iside the MATCH function as the 2nd parameter, the resultant equation errors out.
Any help would be appreciated, thank you.
Bookmarks