'=IF(AND(ISERROR(VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),"n/a",VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),"n/a",VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$O$5:$P$97,2,0)),"n/a",VLOOKUP(A5388,POS!$O$5:$P$97,2,0)),iF(ISERROR(VLOOKUP(A5388,POS!$V$
length is less then 11 then find the solution with
Vlookup and Mid function.
if length if more then 10 then you have to edit the formula and add the
condition.
On Mon, Jun 3, 2013 at 11:35 AM, Vikas Bhosale wrote:
> Hi Frnd here I attached excel file
> Sent from my BlackBerry® Smartphone o
f the cell value length is less then 11 then find the solution with
Vlookup and Mid function.
if length if more then 10 then you have to edit the formula and add the
condition.
On Mon, Jun 3, 2013 at 11:35 AM, Vikas Bhosale wrote:
> Hi Frnd here I attached excel file
> Sent from my
acros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Dear Vikas,
if the cell value length is less then 11 then find the solution with
Vlookup and Mid function.
if length if more then 10 then you have to edit the formula and add the
condition.
On Mon, Jun 3, 2013 at 11:35 AM, Vikas Bhosale
many alphabets are there? are there always 4 alphabets grouped together?
And are always the alphabets in capital letter?
Sandeep
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Vikas Bhosale"
Sender: excel-macros@googlegroups.com
Date: Mon, 3 Jun 2013 05:32:34
:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
and what about value of alphabet ..only till J ...or further also .K
=10.L=11.something.
On Mon, Jun 3, 2013 at 11:17 AM, Vikas Bhosale wrote:
> In single cell some time two some time three ,four,five,six,some t
: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
How many alphabets are there? are there always 4 alphabets grouped together?
And are always the alphabets in capital letter?
Sandeep
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Vikas Bhosale"
Sen
Hi experts ,
I am beginner of excel. And I want to convert alphabet in number . Like.
ABCD = 1234
A=1
B=2
C=3
D=4
E=5
F=6
G=7
H=8
I=9
J=0
In excel one cell there is ABCD I want to convert this alphabet in number like
1234
Other example:
GJIA then need to convert in 7091
Please help me to sol
Happy holi all excel expert.
Sent from my BlackBerry® Smartphone on Loop Mobile.
-Original Message-
From: ashish
Sender: excel-macros@googlegroups.com
Date: Tue, 26 Mar 2013 21:00:38
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Wish you all a very happy holi
Hi Ashish
Thanks Unfortunatily i got this formula from you thanks from 3-4 days i
try to finding this formula once again thanks.
i appreciate you will be help me in future
thanks
On Tue, Apr 28, 2009 at 8:43 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> Hi Savant,
>
> Try this fo
10 matches
Mail list logo
