View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wingale
 
Posts: n/a
Default HELP, PLEASE - Testing Multiple Values


I hope someone can help me here.

I have a workbook with two worksheets (I will call them worksheet1 and
worksheet2), from worksheet1 I need to test the values of two dfferent
columns with the values of two different columns in worksheet2. When
both batches are true - I want to copy the value of another column,
same row as the match from worksheet1 to worksheet2.

Below is my logic, I just don't know how to write in excel:
If value in column 1 of worksheet1 = value in column 1 of worksheet2
and value of column 2 of worksheet1 = value in column 2 of worksheet2,
then copy the content of column 3 (same row) from worksheet1 to
worksheet2.

Thanks so much!!
Winston


--
wingale
------------------------------------------------------------------------
wingale's Profile: http://www.excelforum.com/member.php...o&userid=33467
View this thread: http://www.excelforum.com/showthread...hreadid=533039