VLOOKUP help

[jwevans]

I have a spreadsheet where i use vlookup to pull customer specific info every month and quarter. How do i avoid having to type in the address for the new tab each month? the new tab comes from a different excel file run from the company's servers.

 

[etaf]

What is the TAB called - you could use sheetname based on a month for today() based on an indirect()
to extract the month you want and use that as the range referring to the sheet name
OR add a cell with the name of the sheet in
BUT need a little more info / example

Book2
	A	B	C	D	E	F
1					NewSheetName
2	b	2
3
Sheet1

Cell Formulas
Range	Formula
B2	B2	=VLOOKUP(A2,INDIRECT(E1&"!A2:B5"),2,FALSE)

I have a 2nd sheet

Book2
	A	B	C
1
2	a	1
3	b	2
4	c	3
5
6
NewSheetName

 

[jwevans]

I name the tab for the month or quarter i want to see the data from:

The vlookup formula:

I add a tab each month and quarter with new data from and another spreadsheet

 

[etaf]

you could put the TAB into a cell and refer to that cell on your vlookup

fir example - Cell you put Q3 in

Do you have a free cell on the summary tab you can use to update and reference the TAB you need

=VLOOKUP(A4,INDIRECT(Cell you put Q3 in &"!$E$425:$S$511"),7,FALSE)