Compare and Merge data across two tables


I have a scenario to ask this group.

I have two tables (sheets).

Table 1 has RSVP information
Table 2 has Event Payment information

If Table 2 has a first and last name which matches first/last name in the RSVP Table, add certain column data for that person from table 2 to the matching row in table 1.

Preferably this would be an automatic process on change however if this is not possible an action button per row could work.

Thanks in advance.


1 Like