OK I must have misspoken. 'IF' only returns '0' / 'Yes' or '1' / 'No' ...
that is not what I want at all - what I want may not even be a "Function".
I have two spreadsheets / workbooks whatever you call them ... two separate
In the spreadsheet I want to modify, I have many columns, three of which
columns are 'FirstName', 'LastName' and 'Email'. 'FirstName' and 'LastName'
have people's names in them; the column 'Email' has no entries in it at all -
this is the column I want to populate.
In the other spreadsheet, I also have the same three columns but the 'Email'
column does have addresses populating it.
I want to compare 'LastName's and 'FirstName's between the two sheets so
that I get a perfect match. When I do get a perfect match, I want to
populate the empty 'Email' column in the spreadsheet I want to modify with
the correct email address for that unique individual.
In other words, I may have many "Johnson"s in both sheets; "Dale", "Jimmy",
one spreadsheet to populate the other spreadsheet.
-Thanks for the replies.