Named Range seems to break Formulas

Hi all!

I've been given a list of 30 people who need to be emailed but I was only given their names, and I just need to pull out their correct email addresses.
I've got a full database of about 90 email addresses in column A and the full set of corresponding surnames in column C.
I've put the given list of surnames that I need to match up in column F.

INDEX-MATCH has been doing this perfectly for me using the below formula, but if I change the Array to a named reference with the exact same cell range then I get an error (in attached image). I think I need to use a named reference so I can drag this formula down a column without the Array translating itself automatically to A2:D82, A3:D83 etc.

This works;

=INDEX(A1:D81|MATCH(F1|C:C|0)|1|1)

This doesn't;

=INDEX(tbl|MATCH(F1|C:C|0)|1|1)

Capture.JPG

Even though I set "tbl" as a name that references A1:D81.
I need to do this a number of times so if anyone can help that'd be awesome! Thanks in advance

OH MY GOODNESS YOU BEAUTIFUL CREATURE THANK YOU.

This saves me so much time and improves my workflow massively. Huge kudos :D

Done and done. Thank you again!