Cell value in formula

  • Thread starter Thread starter Marcus Ostman
  • Start date Start date
M

Marcus Ostman

Does anybody know if I can report a value in a cell to formula in a another cell.

For exampel if the value in A1 is "Sheet2"
and a formula in A2 is
=LETARAD(B2;'((A1))'!A:B;2;FALSKT)

Im not sure what 'Letarad' is called in english, Findrow?

/Marcus
 
Hi Marcus!

The english name for LETARAD is VLOOKUP.
I think this formula will help you: =VLOOKUP(B2;INDIRECT(A1&"!A:B");2;FALSE)


Best regards

Stefan Hägglund
Microsoft
 
Back
Top