I have a worksheet of data that is auto-generated and can't be modified. It
has names of accounts, along with contact types and contact names.

Acct1      Sales       Fred
Acct1      Support    Ralph
Acct1      Other       Sam
Acct2      Sales        Tim
etc..

I want to do a vlookup into that spreadsheet, knowing the account name and
contact type, and return the contact name. I can't seem to figure out how to
do an embedded vlookup to do this. Any suggestions? Based on other threads in
this forum, I've thought of using an "IF" statement, but there can be and
unlimited number of contact types, so I would not know how many times to
recurse the "IF". There was also the thought of adding a column to the table
data, concatenating the two fields, but I can't modify the spreadsheet.

Any other ideas?

Thanks,

- Pete