INDEX/MATCH to return cells 4 & 5 places below my Match...

Hi Guys!

I have the following Formula which works great

=INDEX(UKDATA,MATCH(E2,UKDATA,0)+5)

This Looks for a MATCH of Cell E2 within the Range "UKDATA" and returns the 5th Cell below the Match.... Perfect


Is there a way i can not only return the 5th Cell but also the 6th Cell?

I have been trying;

=INDEX(UKDATA,MATCH(E2,UKDATA,0)+5,+6)

&

=INDEX(UKDATA,MATCH(E3,UKDATA,0)+5),MATCHMATCH(E3,UKDATA,0)+6)

But obviously this is not working for me...

Any ideas?

Ali! Thank you... This works perfectly!

Ive been looking at Syntax all morning and going over Tutorials but sometimes if its a specific problem its best to ask.

Thank you for time and effort, i have only started lerning Excel for the past few months and learning alot. Ill now go over how and why your formula works.

Thanks again!

Excellent! That will help me SO much Ali!

The problem i have is that becuase i have been thrown in at the deep end im using some Complex Formulas without a complete understanding of basics and how to
use them together.

Im going to go over all the basics and hopefully i wont need to ask as much in the future... although this forum has been a real help and i have learnt ALOT from you guys!

Thank you Ali