I have several minitables (title, content) organized in a matrix, like the following example:
I want to do a lookup such that I put the “title” value in a cell, and return the content. So, I put a letter in yellow cell and return the content, as in here:
It’s essentially a vlookup and hlookup together, or searching in a matrix rather than a vector. The problem is I cannot find a way to do this for non-numerical data. Lots of formulas require data to be sorted but in my case it does not make sense. The data has a logical order in itself (not in the shown meme example, of course).
Any ideas how can I achieve this? Naturally, stacking the rows together (A,B,C,D,E,F,G,H,I) and then a vlookup would solve the problem, but data must be in such format.
