MS Excel Formula with Indirect Cell/Range referance.

Hi Everyone!

I have indirectly cell number which is showing as a value and formated as general (e.g cell number G48, G944 etc) in a cell in a column and now I want to work with that cell numbers. Such I want to use =XLOOKUP formula

for getting model numbers from another colunm or sheet with the referance of that cell number which is showing as a value in a cell but now how can I put this cell number referecne into my formula,,

Please if any of you have soluation then please reply,, I attach below a screen short and a attach for undersanding,,