Here is an example of my file, two tables, green and orange.
\1

With some help, ive got this formula:
Formula: copy to clipboard
Please Login or Register  to view this content.

and a variation of this formula for the death place field.

It checks the data in the green table (forename, surname, birth place) with the data in the orange table (forename, surname, death place) and if it finds a match, it copies the death date and death place from the orange table to the green table.
It does this fine. But I need it to NOT use the same data from the orange table twice. So in the example above the result of the last row is wrong. It shouldnt use 1934, Bristol England because it used this data in the previous row.

Anyone able to solve this problem?
Cheers