I have a file with two sheets:
  • Sheet A has the raw data.
  • Sheet B is a working sheet, where I add data from Sheet A.

The column with employee ID's is static. The other columns are dynamic. Meaning the employee names are currently in column I, but this might change to column K tomorrow. It will constantly change, based on the changing needs in the upcoming days.

Column H has the Employee ID's and will not change.

An example formula is as follows.

=INDEX(WD_TALENT_INFORMATION_BASELINE[Employee Name],MATCH($H2,WD_TALENT_INFORMATION_BASELINE[Employee ID],0))
Is it possible to replace the "[Employee Name]" part and have it refer to a cell value? In this case, it would be the value in cell I1, as the column header is "Employee Name"?

Obviously, is there's a more logic solution, I'm also happy to hear. Many thanks!