Previous Topic Next Topic

COMPARE COLUMNS IN EXCEL

Closed
Jessica - Jul 19, 2010 at 11:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 20, 2010 at 07:29 AM
Hello,

I have 2 worksheets regarding (4) columns:

Column

A
B
C
D

How do I compare what's in Column A (Worksheet 1) with what's on (Workseet 2) in Column B? IF TRUE, THEN take what's in Column C on (Worksheet 2) and place it on (Worksheet 1) column D?

Related:

2 responses

Answer 1 / 2
Blocked Profile
Jul 20, 2010 at 02:22 AM
Dear Sir,

Please have the task completed through the help of the following Kioskea FAQ articles.

https://ccm.net/faq/

https://ccm.net/faq/

https://ccm.net/faq/

Thanks in advance.
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 20, 2010 at 07:29 AM
Use VLOOKUP
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses