Hello,

I am new to the INDEX & MATCH formula used instead of VLOOKUP and just have a question...

I would like to know how I would reference a table rather than a worksheet in the formula?

For example the formula referencing a different worksheet appears as:

=INDEX(Sheet2!H:H,MATCH('Sheet1'!$A10,Sheet2!$E:$E,0))

I want the 'sheet' references to actually be a defined table. I am having trouble getting the formula to work when I do this.

Any suggestions?

Thank you!