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
Hi
What exactly you are trying to do.
Rgds//Vabs
On Thursday, October 18, 2012 3:05:31 PM UTC+5:30, Manoj Kumar wrote:
>
> Dear Expert,
>
> please help tell me i am doing something wrong in this formula..
> A B c Store ID Store ID V5/A & G-199 #VALUE! V5/A & G-016 V5/A &
> G-016 #VALUE!
