Formula required for comparing multiple colums to multiple colums

**Pringgles** · 07-30-2012, 06:11 AM

Hi,

I wonder if someone could help me??? Im pulling my hair out!!!

I am trying to compare multiple columns to multilpe columns. I have attached a spreadsheet which has 2 tabs (Software and CTI). I want to compare columns A, B and C in the Software tab to columns A, B and C in the CTI tab. The results need to be populated in columns E, F and G in the Software tab. The results in the latter columns should be the correct text, e.g.

Column A Column B Column C | Column E Column F Column G

Software Clothing NSM Monitoring Software Clothing NSM Monitoring

Thanks

**martindwilson** · 07-30-2012, 07:23 AM

In e2
=if(isnumber(match($a2&$b2&$c2,index(cti!$a$1:$a$5000&cti!$b$1:$b$5000&cti!$c$1:$c$5000,0),0)),a2,"")
in f2
=if($e2<>"",b2,"")
if g2
=if($e2<>"",c2,"")

Formula required for comparing multiple colums to multiple colums

LinkBack

Thread Tools

Rate This Thread

Display

Formula required for comparing multiple colums to multiple colums

Re: Formula required for comparing multiple colums to multiple colums

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions