Hi All;
New to this forum.
I apologize if this topic has been recently discussed, but here it is:
Suppose I have a table of data, several columns and several rows.
Is there a way I can do a vertical lookup based on one value, then from that row of data do a horizontal lookup based on another value, and return a single value?
In other words is there a way I can embed both lookup functions in one cell?
Thanks for any help,
Rod
Bookmarks