Cell value in formula

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
 
S

Stefan Hägglund [MSFT]

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy cell formula returns zero instead of cell value 1
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Excel formula, sum the value cell and if empty cell left blank 0
Excel Need Countifs Formula Help 0
How to set cell value to emptry if three other columns are empty too 1
Drop-down list and error message 1
Find largest value in column with 2 criteria 1
add new value with previous in same cell 2

Top