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