view the formula

D

Dinesh

How can I see what is the formula to a link cell?
For example, Sheet1, cell "A1" is linked to Sheet2, Cell"A1". In sheet2,
cell A1 has a formula like =VLOOKUP(N97,'LP Transactions'!$R$153:$R$324,1,0).

The result I like to see on Sheet1, cell A1 "=VLOOKUP(N97,'LP
Transactions'!$R$153:$R$324,1,0)".


Thanks,
Dinesh
 
S

Sean Timmons

If I understand correctly, you just want to see the formula within the cells.

Click CTRL~ to view formulas.
 
E

Eduardo

Hi,
go to Formulas, and under the formula auditing tab click on Show formulas
Hope this helps
 

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

Excel - Wich Function should I use? 1
Need help to fix vlookup function in macro 1
Need Help with a VBA subroutine 0
Automatically populating cells down a row 8
formula referring to a worksheet 4
How Do I Avoid #REF! In Formulas? 5
Vlookup and return sheet name also 2
Use vlookup within offset? 4

Top