Hi,
In a cell say C3, the value is such as S9(09)V(05).

the value of that cell might be in one of the following format:
(1) S(9)V(5)
(2) S9(09)V(05)
(3) S9(9)V(05)
(4) S9(09)V(5)
(5) S(11)

My requirement is: i need to get the numbers extracted which, is present
before & after the letter 'V' & enclosed in parantheses. In some cases, the
letter V may not be there. (for ex: point 5 - here, only one number is there
ie.11)

This extraction should happen ONLY if the cell E3 has the value "COMP-3."


Thanks in Advance.
Venkatesh V