COMPARE COLUMNS IN EXCEL

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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?

2 replies


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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Use VLOOKUP