This ought to be pretty simple, and worse still, I have done a few spreadsheets with similar functions creating sums.

Nevertheless, I have the following problem, that I just can't seem to solve.

On the left-most sheet, labelled "main sheet" I have a column A containing rows with labels for a series of tasks.

Next to each task there is a cells that ought to contain their respective latest entry in a subsheets.

Each task has a subsheet that contains 2 columns.

A, contains a date, DD:MM
B, contains a variable text, referring to what was done on that dae

My problem is, on the main sheet I can't get the cell related to task to show the latest column B entry.

What function should I use? I try to build an IF statement, but it just doesn't work.

Cheers, and thanks in advance,

Trin

Hi Trin,

It sounds like you'll need to use an INDEX() MATCH() combination in your formula such as this:
I've attached an example. Is that what you are looking for?

It looks EXACTLY like what I'm looking for!

Brilliant.. hadn't thought of using index for that.

Thank you very much for your time.

Cheers, Trin