| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to a sheet name that is text in another cell
Is it possible to change the formula below so that the worksheet being
referenced is dependent on another cell? =VLOOKUP($C$4,'Sheet 1'!$H$15:$M$75,2,FALSE) So if I have Sheet 1 Sheet 2 Sheet 3 etc in column A, can I reference the vlookup formula to pick up the worksheet name from column A? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to a sheet name that is text in another cell
Yes, you would use INDIRECT to do that, like this:
=VLOOKUP($C$4,INDIRECT("'"&A1&"'!$H$15:$M$752"),2, FALSE) assuming the first sheet name is in A1, and then copy this down as required. Hope this helps. Pete On Feb 20, 12:54*am, lauren_marie wrote: Is it possible to change the formula below so that the worksheet being referenced is dependent on another cell? =VLOOKUP($C$4,'Sheet 1'!$H$15:$M$75,2,FALSE) So if I have Sheet 1 Sheet 2 Sheet 3 etc in column A, can I reference the vlookup formula to pick up the worksheet name from column A? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I annotate a formula result in Sheet 1 in Sheet 2 by Cell Addr | Excel Worksheet Functions | |||
| How do I set a formula to get text from sheet 2 to sheet 1? | New Users to Excel | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
