xlookup way to do vlookup+match?

[daveyc18]

currently..

=VLOOKUP("TSE Listed",Table_1[#All],MATCH("NO. ORDERS_5",Table_1[#Headers],0),0)

 

[DanteAmor]

Try:

=XLOOKUP("TSE Listed",Table_1[Column1],Table_1[NO. ORDERS_5])

Change column1 to the name of your first column in your table.

Or:

=XLOOKUP("TSE Listed",INDEX(Table_1,,1),Table_1[NO. ORDERS_5])

 

[Peter_SSs]

currently..

=VLOOKUP("TSE Listed",Table_1[#All],MATCH("NO. ORDERS_5",Table_1[#Headers],0),0)

Is there ant particular reason to want to change from the VLOOKUP if that works for you?