| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
evaluate cell value with sheet name
I have different sheet names in column A. I would like to use the
sheet value in A to show a value in a specific cell in that sheet. For example: A12 has 'Test 1 & 2' (no 's) and I would like cells b12 and c12 to be 'Test 1 & 2'!A50 and 'Test 1 & 2'!A60 respectively. However, I do not want to hard code the 'Test 1 & 2' text but would rather use the fact that this string is already available in cell A12. How can I do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel evaluate one cell and return the information in another? | Excel Discussion (Misc queries) | |||
| How do I evaluate a row of cells for a character in each cell? | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| IF function - need to evaluate cell content in 2 separate files-#N | Excel Worksheet Functions | |||
| EVALUATE Function | New Users to Excel | |||
Threaded Mode
