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?
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?