Match 2 excel data sheets

Asked By 7060 points N/A Posted on -
qa-featured

Hi, I got 2 data tables. 1st table content "web address" and there "contact email address"(about 500). 2nd table content only web addresses(about 800)so i need to match the 2nd table web address with 1st table web address and find email address for each web address and copy to 2nd table.

Please tell me how to do it easily.

SHARE
Best Answer by Murakami Wyatt
Answered By 0 points N/A #84322

Match 2 excel data sheets

qa-featured

VLOOKUP will do. If your amount data are in column D of Sheet 2, try placing this into the cell of row 2 in the column in Sheet 1 where you want "amount" returned.

=VLOOKUP(A2,Sheet2!A:D,4,FALSE)

Then drag this formula down the Sheet 1 column as far as you have to. Adjust the A:D and the "4" to match your actual data structure.

Best Answer
Best Answer
Answered By 0 points N/A #196733

Match 2 excel data sheets

qa-featured

Hi,

To compare details from two Excel tables, do the following:

1. Open a blank Excel document and copy-paste the first table.

2. Use Excel's AutoFilter function under the Data tab to arrange the contents of the table alphabetically.

3. Do steps 1 and 2 for the second table.

4. Copy-paste both tables, now arranged alphabetically, side by side.

There you go. Hope this helps.

Murakami Wyatt

Login/Register to Answer

Related Questions