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.
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?