| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Help
Hi,
I need a formula that references a cell (say C2) of one of the worksheets called U3, U4, V3, V4, etc. However, the worksheet to use depends on the value of two other cells (A1 and B1). For example, if the value of A1 is U, the value of B1 is 3, then the formula would become =U3!C2 How can I cook up such a formula, preferably without the use of any vba? |
|
#2
|
|||
|
|||
|
=INDIRECT(A1&B1&"!C2")
"robot" wrote: Hi, I need a formula that references a cell (say C2) of one of the worksheets called U3, U4, V3, V4, etc. However, the worksheet to use depends on the value of two other cells (A1 and B1). For example, if the value of A1 is U, the value of B1 is 3, then the formula would become =U3!C2 How can I cook up such a formula, preferably without the use of any vba? |
|
#3
|
|||
|
|||
|
Try =INDIRECT(A1&B1&"!C2")
Hope this helps Rowan robot wrote: Hi, I need a formula that references a cell (say C2) of one of the worksheets called U3, U4, V3, V4, etc. However, the worksheet to use depends on the value of two other cells (A1 and B1). For example, if the value of A1 is U, the value of B1 is 3, then the formula would become =U3!C2 How can I cook up such a formula, preferably without the use of any vba? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
