HELP: Column Header as a Variable(Structure Referencing)

[nori79]

Hi, Good day! Currently experimenting and trying out functions in excel, hope you guys can help me out. Thanks in advance!

I have two tables, TableA and TableB(see screenshot below), in TableB there is a "Customer" column similar to TableA, I want to display the Column INDEX number of the Customer, for VLookup purposes.

TableA and TableB.JPG


Now, I have this function under "Customer" of TableB
=VLOOKUP([Mobile],TableA,COLUMN(TableA[Customer]),FALSE)

Now, the function above works fine but w I want to automatically get the name of the Column Header of TableB so I won't have to retype the formula or edit the formula.

I tried this formula but it doesn't work for me even with indirect

=VLOOKUP([Mobile],TableA,COLUMN(TableA[TableB[#Headers]]),FALSE)

I tested with Indirect, still doesn't work

COLUMN(INDIRECT("TableA[TableB[#Headers]]")

Kindly help, thanks!

[NeedForExcel]

Maybe something like this

=VLOOKUP([Mobile],TableA[#All],MATCH("Customer",TableA[#Headers],0),0)

[nori79]

Maybe something like this

=VLOOKUP([Mobile],TableA[#All],MATCH("Customer",TableA[#Headers],0),0)

Great Thanks! I just replaced "Customers" with TableB[#Headers] and it worked! Now let me try on one of my trackers

MATCH(TableB[#Headers],TableA[#Headers])

[NeedForExcel]

Glad it helped!