LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allow selection of multiple values in dropdown list in excel Nancy @ CHR Excel Discussion (Misc queries) 2 April 13th 06 10:44 PM
Return Summed Count of Multiple Consecutive Numeric Values Sam via OfficeKB.com Excel Worksheet Functions 4 April 10th 06 10:35 PM
Look up one value and return multiple corresponding values in exce Morphis Excel Discussion (Misc queries) 6 March 31st 06 02:20 AM
vlookup, multiple values, sum values into one cell?? Phillips L Excel Worksheet Functions 4 November 9th 05 12:31 AM
how to lookup a value and return multiple corresponding values Asthee Excel Worksheet Functions 1 November 5th 05 01:49 PM


All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"