Help please!
I am trying match data from two columns, from seperate worksheet and where there is a match, populate the columns with data from one of the worksheet to columns on the other.
With the attached example, on one sheet I have address information (fictitious) and other sheet I have sales information. Where the address number and street address match from the two worksheet, I want to add sale price and sale date in the appropriate column in the address information worksheet.
I have been trying to do this with multiple, nested vlookups, but without any success. Any help would be very much appreciated!
Thanks.
Bookmarks