Vlookup where reference on table array is not in the left most column of the table

[Cailean]

Hi,

Does anybody know of a workaround or have previously tried this:

To reference a value from one table in one sheet to another table of a different sheet using a unique ID common to both, however the unique ID is not in the left most column of the table array.

Thanks.

Cailean.

 

[sheetspread]

For left lookups you can use index/match or vlookup with choose