Forum Discussion

Copper Contributor

Jul 22, 2021

2000 MDs and 3 Sales People - How Do I Search

Hello, I hope you are all well. I have a list of about 2000 MDs that I'm trying to get excel to search and return the Sales person that is assigned to them. It's one workbook, one sheet with the ...

excel

Yea_So

Bronze Contributor

Jul 22, 2021

USMC1114

index+match would be your go to formula. let us know if you need help. It would also help to create similar tables to your spreadsheet with dummy info and if you can share it that would speed things up.

cheers