Index match

[j4ymf]

Good morning
could someone please help me out with an INDEX MATCH
I'm trying to find dates when people are on holiday.
my index are DATES on K27:N27. THE NANE J28:J33. THE HOLIDAYS H29:K28
H28 is the name
H29 is the letter H

so I'm trying to find the name and then the H and return the date that the person has booked off on holiday but currently it returning a N/A error.

and then once that one works I would like to be able to find the next day they have booked off, how do you find the second date, third date?

thanks you



=INDEX(K27:N27+MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

 

[Special-K99]

Is this a typo ???

=INDEX(K27:N27+MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

It should be

=INDEX(K27:N27,MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

For subsequent dates you'd be better off posting some example data

 

[j4ymf]

hello

some post i've read i've seen a + either way i'm still getting the error code
thank you

 

[Aryatect]

Hi,

Can you post some dummy data, some of your ranges are intersecting.

 

[j4ymf]

Hi Aryatect
How do I do that

 

[Aryatect]

Hi,

Use any of the tools in the below link to use an addin to paste the data:

https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html