Hi,
Looking to match columns A and B using Vlookup function. Both columns have same info, just in different rows
Example:
Column A Column B 1 2 3 4 2 3 5 6 6 5
Then after matching Column A with Column B, want to extract corresponding Columns based off of the match.
Example:
After matching Columns A + B,
Column A Column B Column C Column D Column E 3 3 123 MAIN STREET HAPPYTOWN COUNTRY 4 4 123 HAPPY AVE HAPPYVILLE COUNTRY
I am probably wrong about using a Vlookup function, but I want to find a way to do this. Can this be done? And if so, what is the function?
Thanks
Bookmarks