I have this table:
I can select the data from 2021 and put it on F Columnn, using the HLOOKUP function. However, I need to select the data from 2022 and put it on G column, right on the side of the data extracted from 2021 year.
F4=HLOOKUP($F$2,$C$2:$D$13,$B4+2)
Note that "CAR" is only on the "C2" cell.
Is it possible to use HLOOKUP function to accomplish that?