Microsoft Excel Question

Hi Guys,

I know this is probably the wrong section for my question, but it's as close as I could find. If you know which section I should post this in, please tell me & I will try to move the thread.

Anyway...

Does anyone know how I can automate this process in excel so I don't need to do it manually?

Basically I have two spreadsheets. One with just names, and another with a larger set of names (including all the ones on spreadsheet 1) and their respective email addresses. How can I copy across the email addresses onto spreadsheet 1 for the names on spreadsheet 1?

Thanks

Do You think something like this?:

put this code cell B1 on sheet1 then copy the code downward.
=VLOOKUP(A1;Sheet2!A:B;2;FALSE)

The code will work if:
-on sheet1 the names are in column A
-on sheet2 the names in column A and email adresses in column B.

urobee said:

Do You think something like this?:

put this code cell B1 on sheet1 then copy the code downward.
=VLOOKUP(A1;Sheet2!A:B;2;FALSE)

The code will work if:
-on sheet1 the names are in column A
-on sheet2 the names in column A and email adresses in column B.

Click to expand...

Just tried this, and there appeared to be an error in 'A1', going to be researching the VLOOKUP function though.

I stopped using VLOOKUP in favor of INDEX & MATCH, I find it a much better function.