Excel how to take next cell in HLOOKUP?

Question

excel

Hello.
The HLOOKUP formula gives me a value, I need a formula that will return the value to the right of the value that the HLOOKUP formula gave me. That is, the value to the right of the cells from what HLOOKUP found.

Answer 1

The problem is that the formula returns you the value of the cell, not the reference (which you can move relative to). Therefore, I can suggest creating another line with a shift in one cell and taking the value from it.