Forum Discussion

Brass Contributor

Oct 22, 2022

Solved

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

Book1.xlsx66 KB

developer

excel

Formulas and Functions

Macros and VBA

office 365

Office Scripts

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

Riny_van_Eekelen

Platinum Contributor

Oct 22, 2022

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

KAM_Mumin
Brass Contributor
Oct 22, 2022
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 ...

Book1.xlsx68 KB
- Riny_van_Eekelen
  Platinum Contributor
  Oct 22, 2022
  KAM_Mumin Then this should work:
  =INDIRECT("RefModels!"&E2)
  - KAM_Mumin
    Brass Contributor
    Oct 22, 2022
    thanks again,, it works
KAM_Mumin
Brass Contributor
Oct 22, 2022
Brother thanks a lot,,,,