So........who thinks they know Excel?

MarkyMark · 10 May 2006 at 11:50

I've been asked this by a friend: "I need to get the cell to look up a particular project then look at the most "upto date" date and return that info"

This is what she has come up with so far :

=(VLOOKUP($A2,Task!$A:$H,4,FALSE))*AND(MAXA(Task!D: D,Task!D: D))

Anybody able to help us out at all cause now we are both stumped :confused:

Thanks in advance everyone

div0 · 10 May 2006 at 12:22

Can you explain what you are trying to do, in terms of the actual spreadsheet?

Most of the time the solution depends on the layout of your data.

div0 · 10 May 2006 at 12:31

For example how are "projects" layed out? just a column in the worksheet, or a seperate worksheet per project?

And the "dates" that are checked for the most "up to date" - how are these layed out?

That sort of thing...

earlyflash · 10 May 2006 at 22:26

Also worth mentioning that VLOOKUP requires the list to be ORDERED otherwise you get all sorts of weird results.

Definitely post the spreadsheet.