Choosing a cell based on another cell being the most recent.

[seanwilliamsmart]

I have a workbook that contains multiple worksheets, but this issue (for now) entails only 2 of them.

A worksheet entitled 'Performance', includes (among others) a column named 'Date' and another column named 'MLSS'. What I want to do is, from the worksheet entitled 'Waste Rates', grab the 'MLSS' value for the current date (ie today's date, whenever the user is looking at the spreadsheet) and place that result in the 'MLSS' cell in the 'Waste Rates' worksheet.

I've tried using a combo of VLOOKUP and CHOOSE, as found in other message boards, but to no avail.

I'm running Office 2010 on a Win7 system.

Thanks!!

[amotto11]

If on the performance sheet all the dates are different you should be able to do a vlookup. it should go something like this. Vlookup(Today(),$A$1:$B$400,2,FALSE). where A is the date column and B is the MLSS column. you can change the 400 to however many rows you have in your table.

[seanwilliamsmart]

Copy of new daily worksheets.xlsxI've attached the XLS file for you to look at - I tried your suggestion, but still not coming up with the right result Attachment 161216

[amotto11]

Putting in this formula works. You had put a 13 instead of a 15, you have to count all columns even though they are blank. the MLSS Column is 15 over from your date column.

=VLOOKUP(TODAY(),Performance!A2:O400,15,FALSE)

[seanwilliamsmart]

Aha, I must have mistyped - thanks!!