An extension to this problem:

I want to amend this formula:

to this:

and it's fine.

But actually I want to use the WORKDAY function:

but it's not returning the correct results.

Can someone tell me what's wrong?

Thanks

Rich (BB code):

```
https://www.mrexcel.com/forum/excel-questions/1107696-approximate-match-vlookup.html
```

I want to amend this formula:

Rich (BB code):

```
=IF(C3>INDEX($I$3:$I$7,MATCH(A3&"|"&B3,INDEX($G$3:$G$7&"|"&$H$3:$H$7,0),0)),"Y","N")
```

to this:

Rich (BB code):

```
=IF(C3>INDEX($I$3:$I$7,MATCH(A3&"|"&B3,INDEX($G$3:$G$7&"|"&$H$3:$H$7,0),0))+3,"Y","N")
```

and it's fine.

But actually I want to use the WORKDAY function:

Rich (BB code):

```
=IF(C3>INDEX($I$3:$I$7,MATCH(A3&"|"&B3,INDEX($G$3:$G$7&"|"&$H$3:$H$7,0),0))+WORKDAY($I$3:$I$7,3),"Y","N")
```

but it's not returning the correct results.

Can someone tell me what's wrong?

Thanks

_{<strike> </strike>}
Last edited: