SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Excel Formula Needed

(2 posts)
  • Started 1 year ago by emma313823
  • Latest reply from moreeg
  • Topic Viewed 616 times

emma313823
Posts: 1

I am trying to find out what formula I could you for this situation – any idea?

I have an ongoing worksheet with data points and dates – so

COLUMN A COLUMN B

DATE WEIGHT

I have another worksheet which is a high level snapshot of various detail about those data points – ie grand total, averages, and some charts but I want to have a cell on that summary sheet which would show me the last weight entry from column B.

So as an example if I enter the weight for today, I want the cell on the summary sheet to automatically show today's weight value. Is there a formula I can use that would accomplish this?

Posted 1 year ago
Top
 
moreeg
moreeg
Posts: 842

Hi Emma

If we can assume that the last date entered is the most recent date then we can use a vlookup to get what you need e.g.

=VLOOKUP(MAX(Sheet1!A1:A100),Sheet1!A1:B100,2,FALSE)

The MAX statement looks for the most recent date in column A which, to Excel, is also the highest number.

Give this a try and see if it works for you.

Posted 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.

Enter Your Email Here to Get Access for Free:

Go check your email!