Hi everyone...

I have a question !

Sheet1:
A1 (input)

A2, A3, A4, A5
(here I need to get a number 1 depending on input in A1. If I put in A1
:
*G* I will get number 1 in A2
*V* I will get number 1 in A3
*VP* I will get number 1 in A4
*C* I will get number 1 in A5
)


--
alen_re
------------------------------------------------------------------------
alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://www.excelforum.com/showthread...hreadid=503607