IF(ISERROR OR IF(ISERROR THEN...

Amanda Carta

I've been able to get 2 different formulas to check the two different places I need looked up but I can't seem to get them to 1 combined formula. Can someone help me figure out how to make 1 formula that will check 2 places for an entry and say it's Duplicated or No Match please?

IF_OR_Vlookup.xlsx

Mark.poole

@Amanda Carta

See how this formula works out for you

=IF(COUNTIF(Current:Past, = New@row)>0,"Duplicate","No Match")

If you want to make it a column formula. Based on your sample table.

=IF(ISBLANK(New@row), "", IF(COUNTIF(Current:Past, =New@row) > 0, "Duplicate", "No Match"))

Mark.poole

@Amanda Carta

See how this formula works out for you

=IF(COUNTIF(Current:Past, = New@row)>0,"Duplicate","No Match")

If you want to make it a column formula. Based on your sample table.

=IF(ISBLANK(New@row), "", IF(COUNTIF(Current:Past, =New@row) > 0, "Duplicate", "No Match"))

Amanda Carta

I love the new way of looking at it as a count function! That works but… I forgot to mention that Current and Past are on 2 different worksheets. How would I do that?

Amanda Carta

AH HA!!! I got it! :) Thank you for making me think outside the box. I was so stuck on Vlookup :)

=IF(SUM(COUNTIF({Sheet1 Range 2}, Output@row) + COUNTIF({Sheet2 Range 2}, Output@row)) > 0, "Dup", "No Match")

Mark.poole

@Amanda Carta

Glad you worked it out. How ever just an FYI. When you have the sum function you dont need the +

=IF(SUM(COUNTIF({Sheet1 Range 2}, Output@row), COUNTIF({Sheet2 Range 2}, Output@row)) > 0, "Dup", "No Match")