Vlookup table_array text reference question

[MJgreen]

Hi All,
I have a list of 200 worksheets in a master worksheet (going down column A)for which i am trying to use a vlookup for. All of the 200 worksheets in the list are formatted the same, so the table_array range will be the same throughout (i.e., A4:J25). The kicker is that i need to reference the list of each of the 200 worksheets in the table_array as well. So, for example, I need to reference cell A1 which contains the word "Anise" in my vlookup table_array but have no idea how to reference it.

I look forward to getting your advice and please let me know if you have any questions.

Thanks!

 

[GlennUK]

It sounds like you may need the INDIRECT function. I'm not sure, as your description is not very clear.