Returning a row header where a lookup value matches in an array

[Kelvyarh]

Hi,
I am looking for some help with a problem I don't have the skills to solve by myself. I don't have any VBA knowledge, so will be particularly appreciative of any formula's that can solve the problem.

I have a table of unique 6-digit references in a grid (i'll call this the 'table')
Table is from column B-M & row 2-500, so is 10 cells across & near 500 down.
Each cell in this table has either one of three things: one of these unique 6-digit values, nothing (blank cell) or some text that can be ignored.

Sitting in column A, next to the table, I have a list of names that relate to the values in that row.

The Lookup I want to be able to do is in a separate tab:
I have a list of 6 digit references that I would like to use a formula to lookup in the table & if found, return the name in column A.

Table

Dave 123456 / 852159 / 741587
Edna ...... / 856321 / ......
Liam 578965 / ...... / 123587
Aval 784568 / 368412 / ......
Sofs ...... / ...... / 896147
....


References in other tab

852159 / Dave
123789 / N/A
852147 / N/A
784568 / Aval
123456 / Dave
896569 / N/A
123587 / Liam
....


Is there a formula that will be able to return these name values next to the references?

Thanks in advance