I can get the address no problem if I only search it by name: I need to add an additional condition of their companies so now that formula is useless.Īny ideas out there? I don't want to use hidden columns, or 'helper columns' I need to make sure it's the same Chris Evans in 'ClientInfoTable' that I'm looking at in 'ProjectInfoTable' by cross-referencing their companies The trouble I'm running into is there could be a thousand different Chris Evans out there, so VLOOKUP isn't good here. I would like to be able to, while in 'ProjectInfoTable', get the address of the matching Name & Company client in 'ClientInfoTable' I would like to find a match where column a & column b equal and get the address in table 2.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |