I have two spreadsheets (TestSheet1 and TestSheet2)
I would like TestSheet1 to look over TestSheet2 and add address data next to any matching name.
The solution may be vlookup, match or index formula
I am looking for an Excel expert who can provide the formula to solve this problem and provide it in the test spreadsheets provided.
I would like a solution within a few hours if possible and will select the first suitable bidder