|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
07-02-2009, 10:18 AM
|
#1 (permalink) |
|
Registered User
Join Date: Jul 2009
Posts: 1
OS: Windows XP
|
Excel Three coloumn comparison
Hi Guyz,
I am looking to compare three column in excel file and copy the data in 4th column Column1:Data1 Column2:Data2 Column3:Data3 Column4:Data4 (Result data) What I want to do is to compare similar data in Column 1 and Column 3, if the data matched, copy data from Column 2 and paste it in Column 4. Please see the attached sample jpg file. Regards, Aejaz |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
07-05-2009, 07:06 AM
|
#2 (permalink) |
|
Folding Along
Join Date: May 2007
Location: PA, USA
Posts: 1,877
OS: Bobbi=xp, sp3 Muse=Vista Home Premium
 |
Re: Excel Three coloumn comparison
=if(A2=C2,B2,"")
__________________
I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team |
|
|
|
|
| Thread Tools | |
|
|
