Search for text in and then find the catergory associated with it

[Hadoushi]

Hi there everybody, my problem is as follows:

I'm currently capturing Financial Data for my thesis, specifically on securities. The program that I use to do this, however, splits the data by its Group (Sector),e.g. mining, banking, industrial or insurance. When the data is extracted, if the incorrect sector is in the formula it uses, then the data will appear as blank.While I could extract the data sector by sector, certain/most indices have shares from assorted sectors.



Financial mumbo jumbo aside ( ;-) ), what I require is that the Category row states the sector that the stock is in. In other words, I want it to find ABL (for example), from Sheet1 B11 in Sheet 2 A1:343 (which has the stocks and there groups) and then find the sector associated with it from sheet 2.

The main use is that I can use this in the actual cells for the data and associate it with the correct sector.

For example, right now B12 is =RasFinancial(B$11,$A12,120020026,"S.Africa-Industry",$B$1,$B$4,TRUE,"C",$B$3,1)

ABL is Africa Bank Limited, a Banking Sector stock, so the data is blank. Changing S.Africa-Industry to "S.Africa-Banking" solves this. So I want to create a IF statement that will allow the detection of the sector and then use the proper formula.

Something along the lines of =if(B10="industry",=RasFinancial(B$11,$A12,120020026,"S.Africa-Industry",$B$1,$B$4,TRUE,"C",$B$3,1), If(B10="Banking",=RasFinancial(B$11,$A12,120020026,"S.Africa-Banking",$B$1,$B$4,TRUE,"C",$B$3,1), if(B10="insurance",=RasFinancial(B$11,$A12,120020026,"S.Africa-Insurance",$B$1,$B$4,TRUE,"C",$B$3,1), if(B10=mining,=RasFinancial(B$11,$A12,120020026,"S.Africa-Mining",$B$1,$B$4,TRUE,"C",$B$3,1))

Thanks for all your all, in advance.