(Msg. 1) Posted: Tue Nov 03, 2009 2:10 am
Post subject: Return match result Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
example:
book1 sheet1 contains non duplicate values in A1:A10
book2 sheet1 contains non duplicate values in A1:A10
I need a formula to reurn "record matched" or "record not matched" in book2
sheet1 in B1:B10
(Msg. 2) Posted: Tue Nov 03, 2009 2:48 am
Post subject: RE: Return match result [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The below formula in Book2 sheet1 cell B1 and copy down as required
'If book1 and book2 are unsaved open workbooks then
=IF(COUNTIF([Book1]Sheet1!$A$1:$A$10,A1),"Record matched",
"Record not matched")
'If book1 and book2 are saved open workbooks then
=IF(COUNTIF([Book1.xls]Sheet1!$A$1:$A$10,A1),"Record matched",
"Record not matched")
If this post helps click Yes
---------------
Jacob Skaria
"gootroots" wrote:
> example:
>
> book1 sheet1 contains non duplicate values in A1:A10
>
> book2 sheet1 contains non duplicate values in A1:A10
>
> I need a formula to reurn "record matched" or "record not matched" in book2
> sheet1 in B1:B10
>
> thank you if you can be of help!
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office