Problem 1:

`Page-2-Seznam članov > Coloumn C`

: It must be the maximum dates.

The function must search the list for the name of`Page-2-Seznam članov > Coloumn B`

and in the area`Page-3-Podaljsave`

to give the same person the exact maximum output of`Page-3-Podaljsave > Coloumn E`

In `Page 2 > column C > cell C3`

you can use `vlookup`

.

```
=VLOOKUP(B3,'Page-3-Podaljsave'!$B:$E,4,false)
```

A `=sort`

function to guarantee that the output will be the **max** Availability date.

```
=VLOOKUP(B3,sort('Page-3-Podaljsave'!$B:$E,4,false),4,false)
```

Then use a `arrayformula`

to cover the range.

```
=arrayformula(VLOOKUP(B:B10,sort('Page-3-Podaljsave'!$B:$E,4,false),4,false))
```

Be careful, the larger the range in this search, the slower the sheet will be to open / process new data.

Problem 2:

`Page-2-Seznam članov > Coloumn D`

: It must be the maximum dates.

The function must search the list for the name of`Page-2-Seznam članov > Coloumn B`

and in the area`Page-3-Podaljsave`

to give the result of the same person theexact max dateof`Page-3-Podaljsave > Column F`

Same idea:

```
=arrayformula(VLOOKUP(B3:B10,sort('Page-3-Podaljsave'!$B:$F,5,false),5,false))
```

You can combine the two formulas in one table with that in `C3`

:

```
={arrayformula(iferror(VLOOKUP(B3:B10,sort('Page-3-Podaljsave'!$B:$E,4,false),4,false))),arrayformula(iferror(VLOOKUP(B3:B10,sort('Page-3-Podaljsave'!$B:$F,5,false),5,false)))}
```

Bonus: you can reduce `'Page-3-Podaljsave'!$B:$E`

to a table with only two columns: `{'Page-3-Podaljsave'!$B:$B,'Page-3-Podaljsave'!$E:$E}`

then use it in the function like this:

```
={
arrayformula(iferror(
VLOOKUP(B3:B10,
sort({'Page-3-Podaljsave'!$B:$B,'Page-3-Podaljsave'!$E:$E},2,false),
2,false))),
arrayformula(iferror(
VLOOKUP(B3:B10,
sort({'Page-3-Podaljsave'!$B:$B,'Page-3-Podaljsave'!$E:$E},2,false),
2,false)))
}
```