Forum Discussion
If then formula help
Im trying to build a formula for a very long list of employees in my company. An example.... The list of their names are on the column H and I want a new column, Colum R, to automatically add th...
How simple the solution is depends very much on the effort you put in to structuring the problem. Here, I have started with Subodh_Tiwari_sktneer's workbook and inserted some arbitrary names. I converted the lookup range to a Table 'array' and sorted it alphabetically by the first column of employee name.
The lookup formula can then be reduced to
= IFERROR( LOOKUP(EmpName, Array ), "" )
Being a bisection search it is very fast over large datasets.