Hi There
I want to be able to perform a lookup function to search against an orginsation chart based on an employee's unique number. In another sheet i want to compare an organised list that has salary information and employee numbers and pull the FTE value from the org chart.
Because the org charts arent in a uniform i am having issues using a normal index match function. Any suggestions how to create a formula.
The below example has the employee number in the 1st column and the result i wish to retrieve being the 1 value in the 4th column. The orginisation chart has lots of people with the same format however spread across varying location in the sheet. I believe i am having issues as my current formula =INDEX(Editorial!$B$7:$BT$59,MATCH('TEC Feb'!A2,Editorial!$B$7:$BT$59,)) dosent take into account the column match and i am not sure how to have two match functions with the same index. I am also unsure if having my array the same as the lookup field is incorrect. Apologies if my understanding or language used is incorrect.
26689 1.0
Editor (ABC)
Amie Hickland
14464 1.0
Editor (ATN)
Rob McKay
Regards
Andrew
Bookmarks