P
PeteJ
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
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