Dear Joshi da, it works perfectly & thanks for your different idea
except IF formula..
On Sat, Jul 26, 2014 at 1:51 PM, Vaibhav Joshi wrote:
> you can also use:
>
> =VLOOKUP(A1,{"red","us2";"sta","ru2";"ida","cu2";"pco","us3";"pid","ru3";"pde","cu3"},2,0)
>
> Cheers!!
>
>
> On Sat, Jul 26, 2014
you can also use:
=VLOOKUP(A1,{"red","us2";"sta","ru2";"ida","cu2";"pco","us3";"pid","ru3";"pde","cu3"},2,0)
Cheers!!
On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain wrote:
> Dear all , how to merge following six formula into single formula.
> small formula is required . Thanks
>
> IF(A1="red","