help with indirect and lookup

[flier109]

I have an excel spreadsheet which I use for generating invoices.
on my index tab I have a list of names, with a column called "Invoice".
Each tab on my worksheet has a name with corresponds with the names on the index, and I'd like each tab to lookup the name of the tab on the index page and return the invoice number from there, but I can't seem to get it to work.
I'm currently using "=VLOOKUP("Invoice",INDIRECT(Index!A2:E61),5,0)" with the column named "Invoice" being 5 columns along

Can anyone help me to get this working, or is there an easier way?

 

[flier109]

In that case why not put the tab name in a cell & refer to that.

That's great, thanks, thats working well, although I'm still convinced the INDIRECT should have worked so if anyone else has any ideas, I'd love to hear them.

 

[Fluff]

You don't need indirect, in fact you should avoid it wherever possible.

INDIRECT – Excel’s Most Evil Function

My choice for Excel’s most evil worksheet function is INDIRECT, for reasons outlined below. If you have a different choice you can cast your vote for your most evil function (and your favouri…

fastexcel.wordpress.com