I've seen in this forum that someone already asked the question but
there was no answer...
I'm also unable to use the wild character (*) in my IF function - I
want the formula to return $51.44 and $25.31 amounts in column D if
"EXON" chain is encountered in cells of column B. My statement looks
like this: =IF(B4="EXXON*",C4,0) but it doesn't work...

Calumn A Column B
Column C Column D
10/29/2005 HEINIE'S MARKET $12.28
10/30/2005 VAIL PASS SALES 0374 $198.00
10/29/2005 EINSTEIN BROS #1793 $7.54
10/27/2005 EXXONMOBIL75 $51.44 $51.44
10/27/2005 HEINIE'S MARKET $11.97
10/27/2005 EXXONMOBIL35 $25.31 $25.31

Any ideas????
Thanks,
jakar


--
jakar
------------------------------------------------------------------------
jakar's Profile: http://www.excelforum.com/member.php...o&userid=28844
View this thread: http://www.excelforum.com/showthread...hreadid=485929