INDEX/MATCH using multiple worksheets where index is aplhanumeric

OK, I’ve finally bitten the bullet and am trying to use Index/Match in Excel 2016, mainly because the data set being reference 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 reference 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

Hi Glenn
Thanks for the attempt but it STILL woin't work in MY spreadsheet.
My example that you used for your solution differs slightly as I cut it down to keep it simple but the relevant index/natch columns are same/similar EXCEPT the INDEX column in Employees & Contractors on MY sheet is Column B (B8:B27) and the MATCH is Wages & Salaries Column D ($d8 down, relative).
I copied YOUR formula =IFERROR(INDEX('Employees & Contractors'!b$8:b$27,MATCH('Wages & Salaries'!$d8,'Employees & Contractors'!$B$8:$B$27,0)),"") to cell $E8 (note the changes).
All I get is a frozen text version of the formula in $e8 and no relevant data flowing from the Employees & Contractors worksheet.
What am I doing incorrectly?
Do I need to do something with the cell range $b$8:$b$27 on the Employees & Contractors worksheet? (I ask because of what your solution shnows on first line "Named Range" - if so, where does this go and how do I enter it?)
Sorry to be a pain.

Reformatting does not change the display problem. No matter how I enter the formula (copy/paste or type in manually), the cell just displayes the text entered, not the result! Weird.
It works fine in the example you supplied but if I plug it into the actual worksheet it fails!

Into what cell do I type the Named Range formula?

I can't see where ID is mentioned in the INDEX/MNATCH formula you provided.

Sorry to be a pain and I really do apprfeciate the time you arfe taking to resolve my problem.

(BTW, are yoiu still inlocked down Eire? I have 2 very good frinds that live in Cork and they are suffering social withdrawal! Be safe mate!)

Off and on - very erratic.
I get the function working in one row/column and then fill down/across and somethines it works, other times it doesn't.
I have several issues now relating to a basic index/match, where a column fills correctly EXCDPT for one name from the index list and nothing I do will fiox it.
Often, if I copy/paste, the error that I've entered too many parameters pops up yet the formula worked fine without that error in the original cell.
More perp[lexing is the inability to sum a range of values that match both an index marking a quarter and a user name. Is there some way to index/match multiple indices in the same cell?

I am attaching a stripped down version of a workbook with three sheeets that are are interrelated yet either fail to calculate correctly or across the worksheets.

I don't expect you to spend your valuable time on this for too long without compensation but I would appreciate you having a look at what I've done (or not done) - your efforts so far have been awesome and well received. Thank you.

BTW, what is FLYING? Is this some new method of transport? (Unless you are a private aviator, microlight pilot or hangglider, in which case, welcome to the elite group!)

Originally Posted by Glenn Kennedy

I think you need to point out what is not working... and where...

Shall I list the cells for you?