headers/match/tables/vlookup

[DButtgen]

I have a table called "April_2023". I want to reference a cell using vlookup that has "April_2023" in it, to reference that table, and use match to get the column number that matches one of the headers. I thought I could use

Indirect(Cell that had the name "April_2023" in it)[#Headers]

This works: April_2023[#Headers]

The box that I am referencing April_2023 has drop downs with others months with are separate tables. Make sense?

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[AliGW]

If it's A1:

=INDIRECT(A1&"[#Headers]")

If not, provide a workbook.

Your thread title should be descriptive, not a list of function names - please review the forum rules.

[DButtgen]

I believe you have bailed me out in the past, AND, this worked PERFECTLY! Thank you!

[AliGW]

Glad to have helped.

If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.