So, I have a worksheet A and worksheet B.
I would like to compare column A on both sheets with each other.
If the value is the same (true), than copy value from worksheet B, from column F (this value is email address, and it is of course different in every row).
I tried with VLOOKUP, but I cannot figure it out. My excel knowledge is quite poor.
Any help please. Thanks
EDIT: I want to check company names in first sheet against all of the company names in the other sheet. And for those which are the same, copy the emails (which I have only in sheet2)
This question is related to
excel
excel-2007
excel-formula
excel-2010
vlookup
In your destination field you want to use VLOOKUP like so:
=VLOOKUP(Sheet1!A1:A100,Sheet2!A1:F100,6,FALSE)
VLOOKUP Arguments:
Source: Stackoverflow.com