autofill worksheet references?

N

nihad

I am using a vlookup fomula in one worksheet whick looks up the data for
each month....Jan, Feb, March... are the column headings. It looks up
values in another workbook, with worksheets for each month...Jan, Feb,
March...are the worksheet names. Is there a way to autofill the
vlookup formulas to change to avoid retyping the Month reference.?

Thanks
 
G

Guest

Example: sheet1 looks like this:
Jan Feb Mar
foo Janfoo Febfoo Marfoo
bar Janbar Febbar Marbar
foobar Janfoobar Febfoobar Marfoobar

Spreadsheet Jan looks like (extrapolate for spreadsheets Feb and Mar):

foo Janfoo
bar Janbar
foobar Janfoobar

Formula in sheet1:
=VLOOKUP($A2,INDIRECT("'" & B$1 & "'!$A$2:$B$4"),2,FALSE)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top