Hi
You can do that with simple Vlookup function.
Rgds
On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote:
>
> Hi,
>
> I want to know if coll "A" Data found in Coll "C", it found the value of
> Coll "A". using sumproduct..
>
>
> On Thu, Oct 18, 2012 at 3:08 PM, Vabz > wrote:
>
Hi
Then you are getting correcr answer, try Multiplying 1 with Text Value eg.
1 x V5/A & G-040 results in to #VALUE!.
You can get values only data is non text one.
Rgds//Vabs
On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote:
>
> Hi,
>
> I want to know if coll "A" Data found
