Referencing

Greetings,

I need some help with the following.

What formula do I use in Column D if I want to get the values in column C
for those items which has a the word freight in Column A ? Please refer to
the data below.
Column A Column B
Column C

PLP AIR FREIGHT RECOVERY 7/08/2009 0.00
AL CLEVIS THIMBLE 37MM GROOVE 17/08/2009 -490.00
AL CLEVIS THIMBLE 37MM GROOVE 14/08/2009 1,176.00
WIRE ROPE OPEN THIMBLE 20MM DIA 14/08/2009 543.20
PLP AIR FREIGHT RECOVERY 18/08/2009 444.53
TIE DIST 22.60-24.59MM OVER ARMOUR 20/08/2009 1,963.20
PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50
PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50

Cheers!!

In D2: =IF(COUNTIF(A2,"*FREIGHT*"),C2,"")
copy down


"5F80YZ" wrote:

Greetings,

I need some help with the following.

What formula do I use in Column D if I want to get the values in column C
for those items which has a the word freight in Column A ? Please refer to
the data below.
Column A Column B
Column C

PLP AIR FREIGHT RECOVERY 7/08/2009 0.00
AL CLEVIS THIMBLE 37MM GROOVE 17/08/2009 -490.00
AL CLEVIS THIMBLE 37MM GROOVE 14/08/2009 1,176.00
WIRE ROPE OPEN THIMBLE 20MM DIA 14/08/2009 543.20
PLP AIR FREIGHT RECOVERY 18/08/2009 444.53
TIE DIST 22.60-24.59MM OVER ARMOUR 20/08/2009 1,963.20
PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50
PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50

Cheers!!

While using the same logic elsewhere with a different search string you can
try the below formula with spaces padded before and after the text string so
as to have a ** full word ** match.

=IF(ISNUMBER(SEARCH(" FREIGHT "," " & A1 & " ")),C1,"")


If this post helps click Yes
---------------
Jacob Skaria


"5F80YZ" wrote:

Greetings,

I need some help with the following.

What formula do I use in Column D if I want to get the values in column C
for those items which has a the word freight in Column A ? Please refer to
the data below.
Column A Column B
Column C

PLP AIR FREIGHT RECOVERY 7/08/2009 0.00
AL CLEVIS THIMBLE 37MM GROOVE 17/08/2009 -490.00
AL CLEVIS THIMBLE 37MM GROOVE 14/08/2009 1,176.00
WIRE ROPE OPEN THIMBLE 20MM DIA 14/08/2009 543.20
PLP AIR FREIGHT RECOVERY 18/08/2009 444.53
TIE DIST 22.60-24.59MM OVER ARMOUR 20/08/2009 1,963.20
PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50
PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50

Cheers!!

Man, you guys are legends!!

Thanks heaps!!

"Jacob Skaria" wrote:

While using the same logic elsewhere with a different search string you can
try the below formula with spaces padded before and after the text string so
as to have a ** full word ** match.

=IF(ISNUMBER(SEARCH(" FREIGHT "," " & A1 & " ")),C1,"")


If this post helps click Yes
---------------
Jacob Skaria


"5F80YZ" wrote:

Greetings,

I need some help with the following.

What formula do I use in Column D if I want to get the values in column C
for those items which has a the word freight in Column A ? Please refer to
the data below.
Column A Column B
Column C

PLP AIR FREIGHT RECOVERY 7/08/2009 0.00
AL CLEVIS THIMBLE 37MM GROOVE 17/08/2009 -490.00
AL CLEVIS THIMBLE 37MM GROOVE 14/08/2009 1,176.00
WIRE ROPE OPEN THIMBLE 20MM DIA 14/08/2009 543.20
PLP AIR FREIGHT RECOVERY 18/08/2009 444.53
TIE DIST 22.60-24.59MM OVER ARMOUR 20/08/2009 1,963.20
PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50
PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50

Cheers!!