I'm trying to return a value from a table that has an inconsistent number and order of columns.
Let's say my table looks something like this:
What's the best way to return Joe's Age? Again keeping in mind the fact that the "Age" column will change position randomly due to the fact that I'm pulling a dynamic data set, therefore referencing it using "=B4" is no good. The "Age" column will not change in name, so it's safe to search for the correct column number that way, I'm just struggling hard even doing that.