| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a cell in formula to create a reference
Try this:
=INDIRECT(A8&B8) HTH, Elkar "ek" wrote: Below is a sample of a spreadsheet that I am using. The top part is my "raw data area", and the bottom part is my "calculation area". I want to create a formula in C8 that references A8 for the column, and B8 for the row. So when I drag C10 down it will reference A11 and B11, etc. Can anyone help me? Thank you. A B C 1 Data Area 2 Red Yellow 3 Blue Green 4 Purple Orange 5 Pink Black 6 Calculation area 7 Column Row Response 8 A 3 Red 9 B 3 Yellow |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create link of DATA not cell reference in Excel? | Excel Worksheet Functions | |||
| How do I create a cell reference to return name of the tab? | Excel Discussion (Misc queries) | |||
| create reference formula that looks through all sheets for matchin | Excel Worksheet Functions | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
Threaded Mode
