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]

help please.

 

[Arcticwarrio]

Asuming your staring in row 2 put this in M2
[noparse]

=IF(D2="IGI","<img src"&CHAR(61)&CHAR(34)&"http://i536.photobucket.com/albums/ff323/IGMEEGIN/igicert.jpg"&CHAR(34)&">",IF(D2="EGL","<img src"&CHAR(61)&CHAR(34)&"http://i536.photobucket.com/albums/ff323/IGMEEGIN/igicert.jpg"&CHAR(34)&">",IF(D2="GIA","<img src"&CHAR(61)&CHAR(34)&"http://i536.photobucket.com/albums/ff323/IGMEEGIN/Giacert.jpg"&CHAR(34)&">",IF(D2="HRD","<img src"&CHAR(61)&CHAR(34)&"http://i536.photobucket.com/albums/ff323/IGMEEGIN/hrdcert.jpg"&CHAR(34)&">",""))))

 

[Arcticwarrio]

its removing the links when i post lol, i'll find a way

=IF(D2="IGI","<img src"&CHAR(61)&CHAR(34)&"http://i536.photobucket.com/albums/ff323/IGMEEGIN/igicert.jpg"&CHAR(34)&">",IF(D2="EGL","<img src"&CHAR(61)&CHAR(34)&"http://i536.photobucket.com/albums/ff323/IGMEEGIN/igicert.jpg"&CHAR(34)&">",IF(D2="GIA","<img src"&CHAR(61)&CHAR(34)&"http://i536.photobucket.com/albums/ff323/IGMEEGIN/Giacert.jpg"&CHAR(34)&">",IF(D2="HRD","<img src"&CHAR(61)&CHAR(34)&"http://i536.photobucket.com/albums/ff323/IGMEEGIN/hrdcert.jpg"&CHAR(34)&">",""))))

 

[IGinc]

where is the code going to pull the urls from?

 

[Arcticwarrio]

see 2nd reply

Arctic.

 

[IGinc]

Char im assuming is character count? I just realized it should only contain the basic URL...... can I use the same code w/o having to change the Char Value?

Thanks.

 

[Arcticwarrio]

char 61 is an =
char 34 is an "

 

[IGinc]

Should be just:

IGI then M = http://i536.photobucket.com/albums/ff323/IGMEEGIN/igicert.jpg

EGL then M = http://i536.photobucket.com/albums/ff323/IGMEEGIN/eglcert.jpg
GIA then M = http://i536.photobucket.com/albums/ff323/IGMEEGIN/Giacert.jpg
HRD then M = http://i536.photobucket.com/albums/ff323/IGMEEGIN/hrdcert.jpg

 

[Arcticwarrio]

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