Forum Discussion
Solved
Return a range by looking up one cell.
Hi! I'm working on a damage simulator/calculator for a game and I've run into a bit of a snag. I have a bunch of character data setup in little tables (not an actual "Excel Table") and what I'm t...
Have you tried naming the various ranges of data, so that the entire range can be displayed? I don't know for sure that it'll work, but it occurs to me; at least it's something you've not named so far.
I believe I found a solution!
I made a new table with the character names and their respective named ranges.
Then used xlookup wrapped in indirect.
So the final formula looks like this:
=INDIRECT(XLOOKUP(A1, CharData[Characters], CharData[Named Range]))
I'm very grateful for you help. You definitely got me on the right path.
Thank you!
That's good to hear. Glad I could play a part.