The table in Name and Sales amount to enter the salesman name automatically in a cell with the formula in excel
Raw Data
Output Data Data
Formula: =IF(ISNUMBER(B3),$B$2,IF(ISNUMBER(C3),$C$2,IF(ISNUMBER(D3),$D$2,IF(ISNUMBER(E3),$E$2,””))))
Video Tutorial
Download Practice File with Formula (Download.xlsx)