help with simple if then formula

[IGinc]

Criteria:

If D contains

IGI then M = < img src="http://i536.photobucket.com/albums/ff323/IGMEEGIN/igicert.jpg" >
EGL then M = < img src="http://i536.photobucket.com/albums/ff323/IGMEEGIN/eglcert.jpg" >
GIA then M = < img src="http://i536.photobucket.com/albums/ff323/IGMEEGIN/Giacert.jpg" >
HRD then M = < img src="http://i536.photobucket.com/albums/ff323/IGMEEGIN/hrdcert.jpg" >

A formula is fine, I can copy, paste special, and be done, thanks.

 

[IGinc]

Hi Arctic,

Its returning a false value - the formula needs to address the issue IF it CONTAINS those letters..... I believe your formula is assuming D2 = IGI, GIA, HRD, or EGL, which is not the case. D2 Contains other characters.

 

[IGinc]

anyone with a full solution?

 

[Arcticwarrio]

what other characters?

 

[IGinc]

<table style="width: 463px; height: 235px;" border="0" cellpadding="0" cellspacing="0"><col style="mso-width-source:userset;mso-width-alt:14884;width:305pt" width="407"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:305pt" width="407" height="17">1.04 CT ROUND I SI2 GIA CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D IF GIA CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D VVS1 GIA CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D VVS2 GIA CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D VS1 GIA CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D VS1 EGL CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D VS2 GIA CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D VS2 GIA CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D VS2 GIA CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D SI1 EGL CERTIFIED LOOSE DIAMOND</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1.05 CT ROUND D SI1 EGL CERTIFIED LOOSE DIAMOND</td> </tr> </tbody></table>

 

[IGinc]

Those are a few examples. They are not always the 8,9th,10th character for ie.

Mike

 

[IGinc]

still looking for an answer on this....

 

[Arcticwarrio]

This should work

=IF(MID(D2,FIND("IGI",D2),3)="IGI","http://i536.photobucket.com/albums/ff323/IGMEEGIN/igicert.jpg",IF(MID(D2,FIND("EGL",D2),3)="EGL","http://i536.photobucket.com/albums/ff323/IGMEEGIN/igicert.jpg",IF(MID(D2,FIND("GIA",D2),3)="GIA","http://i536.photobucket.com/albums/ff323/IGMEEGIN/Giacert.jpg",IF(MID(D2,FIND("HRD",D2),3)="HRD","http://i536.photobucket.com/albums/ff323/IGMEEGIN/hrdcert.jpg",""))))

Arctic