vlookup return True/False

**okl** · 10-10-2009, 07:46 AM

Hi,

As refer to sample, how can i match "Product 1" column item with "Product 2" item . If match column True/False will return me a "1"

Thankss.

**Special-K** · 10-10-2009, 10:02 AM

In C2

=NOT(ISNA(VLOOKUP(A2,D$2:D$7,1,FALSE)))

and coyp down column C

**Wagstaff** · 10-10-2009, 10:31 AM

Hi

Enter this in C2

=NOT(ISNA(VLOOKUP(A2,D$2:D$7,1,FALSE)))*IF(TRUE,"1","")

**shg** · 10-10-2009, 11:46 AM

=1 - isna(match(a2, $d$2:$d$7, 0))

**okl** · 10-12-2009, 06:48 AM

Thanks,

Add in 1 more:

if "product 1" match "product 2", how can i transfer the "Source 1" data to "Source 2" ?

**okl** · 10-13-2009, 06:47 AM

Anyone please?

Re: vlookup return True/False