I have a table that has two columns of data. The combinations of the data produce statements that need to be reflected in a third column. I know how to use vlookup to see one column. But what about 2 columns with multiple combinations? Attached is a table with the appropriate responses.
The data is in columns H (the rows) and column L (the columns). The responses that need to be placed in a third column (column R) is in the cells in the table.
Any ideas of how to set this up?
Thanks. BTW, you can also email me.
Bookmarks