Looking for A Suitable Formula for My Spreadsheet To Find Exact Matches of Data

Hi,

Could someone please help me find a suitable formula for my attached spreadsheet(example of, the real one has 14031 rows on Col C and D and 2014 on Col A & B. I need to know which customers still owe the same amount of money in August 2012 as they owed in May 2012. Customer ID 1234,14458, 20235 and 24807 still owe the same amount now as they did back in May, they have not made any payments.

I have tried this formula =if(countif(a$3:a$9,c3)*and(b$3:b$9,d3),"Yes","No") (I have typed match,vlookup where and is and so on) I can manage to show Yes where I want on the Customer ID but not a match for Customer ID and The Balance Owing which is what I really need.

I cannot work out where I am wrong, I would be very grateful for some help.

Kind Regards
Lynda

Hello Lynda, and welcome to the forum.

Try this in E3 and copied down:

=IFERROR(IF(VLOOKUP(C3,A:B,2,0)=D3,"Yes","No"),"")

Hello Cutter,

Thank you very much. It worked! I am so happy, I was nearly ready to cry. We currently use 2003 at work and are moving to 2010 in a few weeks, I am one of the helpers, the poor people, I had better start practising. If you know of any good books or a website I could practice Excel and Word on it would be great.

Thanks Again
Kind Regards

Well, now the bad news. That formula won't work with Excel 2003 because IFERROR() was introduced in the 2007 version.

You'll need this:

=IF(ISNA(MATCH(C3,A:A,0)),"",IF(VLOOKUP(C3,A:B,2,0)=D3,"Yes","No"))

I don't know of any good books but there's a sticky post in the Programming sub-forum that contains a lot of links. Although it's primarily for VBA a lot of the links are to sites that aren't strictly VBA. Of course, this site is extremely good for practicing. Cruise the threads and pick one that interests you. Quite often there will be an attachment that you can download and that way you can practice on a file and follow along as help is given.