how to do a look up based on a pair of reference columns|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I am looking for a net and quick war of doing a lookup against 2 columns. 

e.g for the attached file  given "cat" and "test 2" I want the data A8, B8, C8 and so on.

I make a lot of use of Excel for doing structured documentation and am trying to product an automated risk assessment tool that can take historical or new data and so I potentially need to use 2-4 reference values to define the required output cell.  I have recently move to 365 and was hoping I could do something neater than building intermediate tables.

yours

Chris Lowe