Is there a way to lookup information in a table using both colm A and B as
the lookup value?

For example I have a list of names in Colm A and in Colm B I have one of the
four (1) Premium (2) Comm (3) Paid (4) Profit. The four things in colm B are
listed over and over again for each name in colm. Colm's C - ?? are months
Jan - Dec.

I need to be able to write a formula that will find Cindy in colm A and
Premium in colm B and then return the x colm #. Just like vlookup only with
two lookup values.

Hope this makes sense. Any help will be greatly appreciated.