OK, I’ve finally bitten the bullet and am trying to use Index/Match in Excel 2016, mainly because the data set being referenced is not in numerical order and the value I want to find is alphanumeric so vlookup won’t cut it. To compound the issue, the data set being referenced is on a different worksheet in the workbook!
I have 2 worksheets – one labelled Contractors & Employees (this contains employee details and tax status), the other is a timesheet labelled Wages & Salaries (this contains the calculations of employees hours, wages and tax to be deducted.
I simply can’t get index/match to pull the correct value from Contractors & Employees worksheet into the Wages & Salaries worksheet.
Data validation from a list works but needs to be re[peated for each column relevant to the employee’s circumstances. I ideally want to eliminate that so that I can select an employees ID number (alphanumeric) from a validation list on the Wages & Salaries worksheet and have the remaining columns auto-fill the relevant data from the Contractors & Employees worksheet.
I’ve tried adapting many different formulae shown in tutorials on the web but none seem to address the issue of alphanumeric index on a different worksheet!
Help?
Thanks
I have 2 worksheets – one labelled Contractors & Employees (this contains employee details and tax status), the other is a timesheet labelled Wages & Salaries (this contains the calculations of employees hours, wages and tax to be deducted.
I simply can’t get index/match to pull the correct value from Contractors & Employees worksheet into the Wages & Salaries worksheet.
Data validation from a list works but needs to be re[peated for each column relevant to the employee’s circumstances. I ideally want to eliminate that so that I can select an employees ID number (alphanumeric) from a validation list on the Wages & Salaries worksheet and have the remaining columns auto-fill the relevant data from the Contractors & Employees worksheet.
I’ve tried adapting many different formulae shown in tutorials on the web but none seem to address the issue of alphanumeric index on a different worksheet!
Help?
Thanks