-1

I have a sheet where I want to get value in other sheet based on a column for Example.

If the value of Z2 is 10 on sheet 1 than on sheet 2 I want to get value of A10 if value of Z2 is 25 than i need sheet 2 to get value of A25 and so on

John Coleman
  • 51,337
  • 7
  • 54
  • 119
Prateek Kalra
  • 57
  • 2
  • Possible duplicate of [Dynamic INDIRECT formula with range](https://stackoverflow.com/questions/22437086/dynamic-indirect-formula-with-range) – GalAbra Jan 28 '18 at 15:14

1 Answers1

0

try,

=indirect(address('sheet1'!z2, 1, 4, 1, "sheet1"))
  • 1
    thanks exactly what i was looking for :) can you please explain me a bit how formula work because i need to get multiple values Thanks a lot again – Prateek Kalra Jan 28 '18 at 15:00