I have below set of data in excel and would like to create formula in next tab, so whenever I type dealer #, agent name should populate automatically in another tab.
Dealer # Agent
720486 AART
720548 BCCD
720962 SISI
719728 PRUF
720541 PARA
719730 PROF
720280 TOSS
721007 TFIT
720516 DOTD
720526 DHTD
Please help, thanks in advance.