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