Refresh or update?

[mel1660]

I need to look up the latest entry from the consumption table worksheet B1 to B5 and display the result in another worksheet, Tank Condition report. The data on the consumption table is being constantly updated. I tried using Vlookup without any success, any help will be greatly appreciated. Thank you very much





CONSUMPTION TABLE
A B C
1 231.54
2 345.87
3 246.75
4
5


TANK CONDITION REPORT
A B C
1 ?Formula
2
Thank you very much to all of you. You have been most helpful.I was able to finish my worksheets on time. .

 

[jim may]

Would you have any problem setting Tools, Options Calculation to Automatic? Once done in your
TANK CONDITION REPORT tab
Cell B1 enter:
='CONSUMPTION TABLE '!B1
Copy it down as far as needed.

 

[jindon]

Hi

If the last cell in Col. B is the latest entry then try

=Vlookup(10^10,'consumption table'!B:B,1)

hope this helps
jindon