Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

MS Excel Formula with Indirect Cell/Range referance.

Brass Contributor

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,,

kammumin_0-1666434797953.png

 

5 Replies
best response confirmed by KAM_Mumin (Brass Contributor)
Solution

@KAM_Mumin Not sure I follow, but just type =INDIRECT(E2) in F2 and copy down.

Riny_van_Eekelen_0-1666435489069.png

 

 

 

Brother thanks a lot,,,,

@Riny_van_EekelenBrother if i want to put another sheet referance then what is need to do? because the cell number showing those are another sheet cell number,,, please ...

kammumin_0-1666441305099.png

 

@KAM_Mumin Then this should work:

=INDIRECT("RefModels!"&E2)
thanks again,, it works
1 best response

Accepted Solutions
best response confirmed by KAM_Mumin (Brass Contributor)
Solution

@KAM_Mumin Not sure I follow, but just type =INDIRECT(E2) in F2 and copy down.

Riny_van_Eekelen_0-1666435489069.png

 

 

 

View solution in original post