•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
need to populate the Account IDs from Tab 2 and Tab 3 into Tab 1 for the matching customers
I have an Excel file with three sheets: Tab 1, Tab 2, and Tab 3.
I need to identify duplicate Customer Names between:
- Tab 1 and Tab 2
- Tab 1 and Tab 3 (separately)
I already used COUNTIF to mark duplicates (0 = not found, 1 = found).
Tabs 2 and 3 also contain an Account ID column.
Now I need to populate the Account IDs from Tab 2 and Tab 3 into Tab 1 for the matching customers.
I’m not sure how to do this and I’m new to Excel. Could you explain the steps?
[link] [comments]
Want to read more?
Check out the full article on the original site