==== Need to extract string from comma delimited cell in EXCEL ====

[Lynux]

I have a range of cells I have combined to make one column of comma seperated value cells. What I now need to do is look through that column for a value and if value is located extract only the last three characters of the comma delimited cell.

Example:
|__A__|
1,5,330
1,4,450
1,3,560
((I need to look through this column, find the column containing 1,5 and display only 330))


(I am sure this includes an =IF, =Vlookup, and maybe =Find, and possibly =MID function but not sure in what order and how to impliment exactly)

Thanks in advance ! =================================
Imagination is more important than knowledge.
(A.E.)

 

[LSTAN]

Hi lynux,

You can try the below,

=IF(MID(A1,1,3)="1,5",MID(A1,5,3),0)

Hope this can be of some help to you.

Regards

LSTAN

 

[Dreamboat]

=IF(LEFT(A1,1,3)="1,5",RIGHT(A1,3),"&quot

http://www.TheWordExpert.com