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