Thanks for your response!

I did look at the resource and play about with it in my own database but I can only come up with '#NUM!"' I'm afraid. The reference you gave me deals with the VLOOKUP function which I am not using (I'm using INDEX/MATCH to yield my first result because I'm looking-up what's in column E, not the first column which is what VLOOKUP does) and also is used within the same worksheet whereas I am trying to copy the information to a separate worksheet.

I just don't understand enough about it to get somewhere and this can really help me with my work.