|Could you explain what you mean by a "column number B1 to Z1 interacting with a row number in B2 to B20?"|
What formula are you using to display the answer?
In addition, where are you looking to display the orginal 2 cells that provided the "answer"? Will they be concatenated into one cell or be placed side by side?
I think we need a little more detail, perhaps with some examples of data and the "answers" they provide.