Hello,
I would need some help in crosschecking 2 sheets from an excel file, actually i need to run through every row in a column from one sheet and compare it to every row in a column from the second sheet. The number of columns is quite big so puting it all together in one sheet and sorting it is not an option.
Thanks,
Paul
Last edited by burner; 12-16-2008 at 08:21 AM.
Hello.
could u plese upload sample file ?
Here are some sample files, so i need chechek the names in sheet 2 with the ones in sheet 1 , eventhough they are not on the same column.
Have you tried MATCH. See attachement.
A VBA code is a possibility, but I prefer worksheets functions.
=MATCH(A1,Sheet1!A:A,0)
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
yes this function works ok with word but not with numberswhen i try with numbers i get errors
See formula in green coloured cells in attached file
Numbers are even easier
=SUMPRODUCT(--(A1=Sheet1!$B$1:$B$20))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks