excel 2003 matching two numbers in two sheets

August 10, 2011 at 04:16:55
Specs: Windows XP
I have a sheet 1 as a master sheet now in there i need how many account numbers match so if 3 matchs it would say three.

now in sheet 5 is where the data come in and the sheet 6 is the pre callers name.

now the pre caller would give a the account number in.
on sheet 5 is where the customer would rate the tech but it shows the account number
so i need excel to look at sheet 5 and 6 is match the numbers and then say 3 matches on to the master sheets.

Now i work at home with 2010 and i can get this to work with match. in work i use 2003 and i can not get it to match or if it does it will come back as say 73 matched and this is the problem as it looking at all the numbers and saying i.e 13 6 founds etc. can any one help please.

cheers
chris


See More: excel 2003 matching two numbers in two sheets

Report •


#1
August 10, 2011 at 05:49:53
As far as I know, therre is no difference between the MATCH function in 2003 vs. 2007.

If the function works in one version, it should work in the other.

Are you trying this in the exact same workbook in both versions or different copies of the workbooks?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 10, 2011 at 06:43:48
i have tryed both , i also thought the same.

Report •

#3
August 10, 2011 at 07:47:43
Please post the "working" MATCH function that you are using along with a sample of your data so we can try some tests.

Before you post any data, please click on the following line and read the instructions found via that link. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question