INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges

I have a workbook with a lot of tables that have all been named.
I am trying to do a lookup for data within whichever table the user has selected.
I cannot therefore specify the MATCH array as that will change depending which table I need to look up from. I thought I may be able to use OFFSET MATCH MATCH but am having trouble getting that to work also (getting #VALUE error)

I have tried to attach a sample of what I am working on but am struggling to put into words exactly what it is I am after so please ask questions, as many as needed!

TIA Andrew