i have 1 large table range with various data.my intention is to match any column in table range and return with value in right side of the column? most common formula is to use vlookup or match,index but it specific with column or row only..i attach part of table range pic...hope anyone can help me.tqsm