Using IF and SEARCH functions

**visionwindowfilms** · 07-01-2010, 08:32 AM

Im looking to create a formula for a spreadsheet which I will use in column N and ask it to search column B then if column B has the text 70% somewhere within the sentence column N would be the following text http://www.luxico.com/imagehosting/7...w-tint-car.jpg then also for the following

If column B has the text "50%" column N will be http://www.luxico.com/imagehosting/5...w-tint-car.jpg

If column B has the text "35%" column N will be http://www.luxico.com/imagehosting/3...w-tint-car.jpg

If column B has the text "20%" column N will be http://www.luxico.com/imagehosting/2...w-tint-car.jpg

If column B has the text "5%" column N will be http://www.luxico.com/imagehosting/5...w-tint-car.jpg

Please note that column B may have the following text Pre Cut Car Window Tint for a Alfa Romeo 147 3 door Hatchback (2001-2009) Rear Kit in 70% Ultra Light Tints so the percentage will be in there as in this case 70% but not alone, it will be with other text.

What's the best way for me to go about doing this?

**DonkeyOte** · 07-01-2010, 08:59 AM

You could perhaps use something along the lines of:

="http://www.luxico.com/imagiehosting/"&0+MID(A1,SEARCH("%",A1)-2,2)&"-percent-car-window-tint-car.jpg"

(assumes % appears once and once only in each string)

If you want the above as a Hyperlink encase the above within HYPERLINK function.