by Alex
Last Updated April 23, 2018 16:01 PM

I’m doing this, but it doesn’t work:

`=&ROW(D(RIGHT(A21, LEN(A21)-SEARCH(" ", A21, 1))))`

I want to calculate the find number from a different cell, and append it to `D`

row to get for example: `D8`

Any suggestions?

You can accomplish this one of two ways. Take a look at the function

```
=INDIRECT(ref_text)
```

The "ref_text" can be text that refers to a cell. For example if I put:

```
=INDIRECT("A1")
```

where "A1" is text, I can reference a cell. You can piece together the text in this function using other formulas like yours in the original post.

Another way that may work for you as well is to use the function

```
=OFFSET(reference, rows, cols, [height], [width])
```

to which you reference a cell initially and then tell the function how many rows or columns you are away from that cell.

- Serverfault Help
- Superuser Help
- Ubuntu Help
- Webapps Help
- Webmasters Help
- Programmers Help
- Dba Help
- Drupal Help
- Wordpress Help
- Magento Help
- Joomla Help
- Android Help
- Apple Help
- Game Help
- Gaming Help
- Blender Help
- Ux Help
- Cooking Help
- Photo Help
- Stats Help
- Math Help
- Diy Help
- Gis Help
- Tex Help
- Meta Help
- Electronics Help
- Stackoverflow Help
- Bitcoin Help
- Ethereum Help