: $$Excel-Macros$$ Find the cell value from other sheet
Thanks for your revert rajan, but i've one query ma sheet(report) contains
text line as A112354 xyz abc etc or xyz A112354 abc etc in several row
of sheet and other sheet(user id) contains only A1123 now i want to know
if A1123 available
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find the cell value from other sheet
=IF(SUMPRODUCT(--(LEFT(Sheet1!$A$1:$P$21,5)=Sheet2!A1)),Found,Not Found)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: prabhat.shrivasta
See the attached file.. Result on Sheet 2
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prabhat.shrivasta...@gmail.com
Sent: 29 April 2012 22:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find the cell value from other sheet
Thanks for your revert rajan, but i've one query ma sheet(report) contains text
line as A112354 xyz abc etc or xyz A112354 abc etc in several row of sheet
and other sheet(user id) contains only A1123 now i want to know if A1123
available in sheet(report) or nt...
Regards,
Prabhat S
--
FORUM