If Column C matches Column A or Column B return match or if no match, return 0

**santaci** · 05-28-2013, 02:32 PM

I'm working with some SNPs and like the title, I want to see if Column C matches Column A or Column B and if it does, return that match in Column D. If there is no match return 0 in Column D.

I tried this and failed:

=IF(COUNTIF(C1:C1,A1 or B1),A1 or B1,0)

I also attempted:

=IF(COUNTIF(C1:C1,OR(A1,B1)),OR(A1,B1),0)

also failed

**Pete_UK** · 05-28-2013, 02:38 PM

You refer to columns A, B C and D in your description, but your example formulae refer to columns E, F and H.

Pete

**santaci** · 05-28-2013, 02:39 PM

I've edited the columns in the formulas.

**Pete_UK** · 05-28-2013, 02:43 PM

Try this:

=IF(OR(C1=A1,C1=B1),C1,0)

Hope this helps.

Pete

**Tony Valko** · 05-28-2013, 02:44 PM

Can you post a few rows worth of data and tell us what results you expect.

A "few" = 5 to 10.

If Column C matches Column A or Column B return match or if no match, return 0

LinkBack

Thread Tools

Rate This Thread

Display

If Column C matches Column A or Column B return match or if no match, return 0

Re: If Column C matches Column A or Column B return match or if no match, return 0

Re: If Column C matches Column A or Column B return match or if no match, return 0

Re: If Column C matches Column A or Column B return match or if no match, return 0

Re: If Column C matches Column A or Column B return match or if no match, return 0

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions