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