How to Select Automatic a Name from Column with Formula in Excel

The table in Name and Sales amount to enter the salesman name automatically in a cell with the formula in excel

Raw Data

Raw data to enter name automatically

Output Data Data

output data after formula to enter name automatically

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)

Download Excel File

Download more Excel Project Files

Leave a Comment