I need to concatenate numbers in the left column to letters in the top row, re-using the top row letters 4 times for each of the numbers on the left.
It would be nice to include a look up of the merged column/row value with the result.
Please see attachment for more details.
thanks in advance.
Last edited by dcningbo; 06-18-2014 at 03:52 PM.
Try this
H2: =INDEX($A$2:$A$7,INT((ROWS($1:1)-1)/4)+1)&INDEX($B$1:$E$1,MOD(ROWS($1:1)-1,4)+1)
I2: =INDEX($B$2:$E$7,MATCH(LEFT(H2,LEN(H2)-1),$A$2:$A$7,0),MATCH(RIGHT(H2,1),$B$1:$E$1,0))
Amazing, it works.
Thanks so much!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks