Thread: IF conditional to copy column from one spreadsheet to another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default IF conditional to copy column from one spreadsheet to another
If you look up AND in Excel help, it'll show you the syntax for the AND
function.
--
David Biddulph


"TagTech" wrote in message
...
What is the formula to copy email addrs from one sheet column to another
sheet column IF Lname = Lname AND Fname = Fname in the same workbook?

=IF((E2=Sheet1!C2 AND F2=Sheet1!B2),(K2=Sheet1!A2),(K2))

is not getting the job done. Result = #NAME?


Reply With QuoteReply With Quote