For Excel Tables, an Index/Match formula would look something like this:
=INDEX(Table1[ColumnHeader1],MATCH(Sheet1!$A10,Table1[ColumnHeader2],0))
Without seeing how your data is setup, it is hard to give you more help beyond that.