Look up data

[caz46]

Hi,



I have 2 tables, one which contains the names of those invited to a conference and the other is a database of everyone including their location. I would use the 2 tables to say that if I match the name in table 1 with one in table 2, then their location will be entered into a new cell in table 1.

I hope that's clear.

Thanks in advance
Caz

[KunleExcel]

=INDEX(array:location column in Table2,MATCH(lookup_value:name in Table1,lookup_array:column containing names in Table2,match_type:0))