nt: 30 April 2012 18:28
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...@g
legroups.com
Subject: RE: $$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) contai
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
--
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
