Excel vlookup is super easy 😏
You may forget It to do vlookup. Let me show you the way.
Table Overview
let's say we want to add wages to Table A
Set the Lookup Value
The first thing, we choose which name to find in Table B. Let's pick B4
Set the Table Reference
Set the Table B. Select B10:C11, you can also choose B9:C11
Set the Column Location
1 for the "Name" Column and 2 for the "Wages" Column. You get it?
Set to Exact Match
The last thing just put 0 or FALSE in the last
The Results
Then add the column title and you've added the wages column from Table B to Table A
Bonus Tip
Add IFERROR to remove the error
Final Result
The clean data is ready for you
