paddyg1233
New member
Hi i have a table of values, as example
Headers
ID Name Age Occupation Reg Date
1 Bob 30 Cleaner 01/01/2024
2 Edd 28 receiptionist 01/10/2023
In a new sheet i have another table with
ID Occupation
1 Cleaner
I want to add a column to this second table that would Vlookup the ID in the other sheet and look up the occupation in the other sheet and if both values match then bring back the Reg date against that ID and Occupation.
Result
ID Occupation Reg Date returned from other table
1 Cleaner 01/01/2024
Headers
ID Name Age Occupation Reg Date
1 Bob 30 Cleaner 01/01/2024
2 Edd 28 receiptionist 01/10/2023
In a new sheet i have another table with
ID Occupation
1 Cleaner
I want to add a column to this second table that would Vlookup the ID in the other sheet and look up the occupation in the other sheet and if both values match then bring back the Reg date against that ID and Occupation.
Result
ID Occupation Reg Date returned from other table
1 Cleaner 01/01/2024