Displaying the full formula in Excel

[legento]

Hi Everyone,

Thanks for looking,

I need to display the full formula in excel showing the sheet references. Once I set Excel to show formulas I get something that looks like this;

=IF(VLOOKUP(A2,'Letting Dump'!C:F,2,0)<>0,VLOOKUP(A2,'Letting Dump'!C:F,2,0),"Vacant")

What i need is for the references on the current sheet to be displayed in full for example, instead of just refering to a2, I need it to show 'current sheet name'!a2,

In other words, the formula references cells on another sheet and displays the full reference i.e. 'Letting Dump'!C:F I need to see the current sheets name in the reference for cells on the sheet itself.

Any help would be appreciated, prefer not to use a macro.

Thanks

 

[Joe4]

Welcome to the Board!

I need to see the current sheets name in the reference for cells on the sheet itself.

You would need to amend the formula yourself to include the sheet name reference in front of that range. Since Excel does not require it for ranges on the same sheet, it will not show it to you by default.