Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autofill worksheet references?
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 -- nihad ------------------------------------------------------------------------ nihad's Profile: http://www.excelforum.com/member.php...o&userid=30285 View this thread: http://www.excelforum.com/showthread...hreadid=538476 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autofill worksheet references?
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) -- Kevin Vaughn "nihad" wrote: 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 -- nihad ------------------------------------------------------------------------ nihad's Profile: http://www.excelforum.com/member.php...o&userid=30285 View this thread: http://www.excelforum.com/showthread...hreadid=538476 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I autofill an excel worksheet with contacts from outlook? | Excel Worksheet Functions | |||
Identifying/Eliminating Worksheet References | Excel Discussion (Misc queries) | |||
Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
Copy worksheet without absolutle references | Excel Worksheet Functions | |||
Replicating Formulas with Various Worksheet References | Excel Worksheet Functions |