I need a VLOOKUP that doesn't search the entire range of the column, but from an address that changes depending on the current cell.

```
company1 user1 01/2020
fixed val2 1200,00
fixed val2 1100,00
fixed val15 3000,00
company1 user2 01/2020
fixed val13 500,00
fixed val65 200,00
```

What I'm trying is to make the VLOOKUP search the values of each "user". I already identified the "header" of each user with another formula to get the correct address, so I can VLOOKUP it.

So the formula is:

```
VLOOKUP(<value to be found>,<formula to start cell> : <formula to last cell>,<return column number>)
```

The problem is that the addresses comes with quotes no matter what I do.

The `formula to get the start cell`

part is the problem. I tried with NO sucess:

```
CELL("address",INDIRECT(<cell with the address without quotes>,1))
```

Outside the VLOOKUP it returns without quotes, but inside the formula the quotes are always present. Even if I use ADDRESS() inside the formula above it returns with quotes anyway. Can somebody help me with that?

`CELL`

outside of`INDIRECT`

.`INDIRECT`

is used to feed a cell reference into another formula; using`CELL`

to get its location is redundant.