I know this is possible, but could you please assist. See attached. I have a table and I was to do a look across and up? Maybe I am building the lookup table wrong?
I have a code and a value and I want to know based on that code and value, what category it falls in? but the categories are currently placed in the top of each column.
Thanks!
Bookmarks