Dear Mandeep
Sorry for too delay reply .Actually I was on different project and now back
to the home.
Please find attached file.
Marked in yellow is not giving results as I am using Vlookup with ABS
function ,marked in brown gives results I am using Vlookup without ABS
function.
If I used the
Dear Ashish,
Thanks for reply.
Problem solved but I want to know ,what differece (-- ) this makes.
Can you explain it please
Regards
Shrinivas
On Sat, Jun 13, 2015 at 5:33 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Make a little changes in your formula as mention below, then lookup
-- is used to convert it to numeric value it can give the result of true to
1 and false to 0. you were not getting the result just because the numbers
are stored as text which you are getting from the formula.
Regards,
MandeepBaluja
Learningzmypassion.
Make a little changes in your formula as mention below, then lookup on that
value.
=--MID(A9,FIND(1,A9,1),6)
On Sat, Jun 13, 2015 at 1:07 PM, Shrinivas Shevde shrinivas...@gmail.com
wrote:
Dear All
I have a text in Column A4 ,I am extracting a number from that text in
colum B4,using outcome
What is the lookup value
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: Tuesday, December 17, 2013 5:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vlookup query
--
Rajesh Kumar Agarwal
9811063001
--
I want to put vlookup in 7th to 9th row in column A to J from sheet 1.
On Tuesday, December 17, 2013 5:42:18 PM UTC+5:30, ravinder negi wrote:
What is the lookup value
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *Rajesh
Dear Kartik
thans adn appretiate for the effort.
for the example its ok but for actual it will not work as in actual Column
B and Column D are totally different in column B there is PO no and in
Column D there is PR no which are 2 different series at all .for Eg Pr no
is 082364 and PO no is 001257
Thanks to all problem solved
On Thu, Nov 21, 2013 at 3:58 PM, Shrinivas Shevde shrinivas...@gmail.comwrote:
Dear Kartik
thans adn appretiate for the effort.
for the example its ok but for actual it will not work as in actual Column
B and Column D are totally different in column B there is
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Wednesday, November 20, 2013 5:11 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup query
Dear All
Please find attached query.
Is it possible to write
Dear Ravindra
thanks for reply
VLOOKUP($J5,CHOOSE({1,2,3,4},$D$4:$D$7,$C$4:$C$7,$E$4:$E$7,$B$4:$B$7),COLUMN(B$1),0)
In the above formula in choose function you wrote (1,2,3,4)but I have more
than 2000 records.
then how to do
regards
Shrinivas
On Wed, Nov 20, 2013 at 5:19 PM, Ravinder
-Macros$$ Vlookup query
Dear Ravindra
thanks for reply
VLOOKUP($J5,CHOOSE({1,2,3,4},$D$4:$D$7,$C$4:$C$7,$E$4:$E$7,$B$4:$B$7),COLUMN
(B$1),0)
In the above formula in choose function you wrote (1,2,3,4)but I have more
than 2000 records.
then how to do
regards
Shrinivas
On Wed, Nov 20, 2013
Of *Shrinivas Shevde
*Sent:* Wednesday, November 20, 2013 5:29 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Vlookup query
Dear Ravindra
thanks for reply
VLOOKUP($J5,CHOOSE({1,2,3,4},$D$4:$D$7,$C$4:$C$7,$E$4:$E$7,$B$4:$B$7),
COLUMN(B$1),0)
In the above formula
Hi Shrinivas,
PFA, Let me know if you need any changes required
Regards,
Cartik
On Wed, Nov 20, 2013 at 5:10 PM, Shrinivas Shevde shrinivas...@gmail.comwrote:
Dear All
Please find attached query.
Is it possible to write aformula as per my requirement
--
Shrini
--
Are you =EXP(E:RT)
You can use vlookup or sumif 3 times and add all three
On 11 Nov 2013 17:27, Shrinivas Shevde shrinivas...@gmail.com wrote:
Dear All
In vlookup we are giving the column no from which value should be picked
up .
I want to get the summation of 3 column is it possible?
For Eg
I want to get the
Dear Vinay
Thanks for reply
Actually I want to sum of more than 40 column
Regards
Shrinivas
On Mon, Nov 11, 2013 at 5:51 PM, Vinay Saraf vi...@vinaysaraf.com wrote:
You can use vlookup or sumif 3 times and add all three
On 11 Nov 2013 17:27, Shrinivas Shevde shrinivas...@gmail.com wrote:
You can insert one column which contain sum of all 40 column and you can
use vlookup on that column
On 12 Nov 2013 09:21, Shrinivas Shevde shrinivas...@gmail.com wrote:
Dear Vinay
Thanks for reply
Actually I want to sum of more than 40 column
Regards
Shrinivas
On Mon, Nov 11, 2013 at
It's very simple to Sum of more than one column. You can use SUM function
by different type of range as mention below.
=SUM(AV2:AV15)+SUM(AW2:AW15)
=SUM(AV2:AW15)
On Tue, Nov 12, 2013 at 9:55 AM, Vinay Saraf vi...@vinaysaraf.com wrote:
You can insert one column which contain sum of all 40
Please send me the file I have the solution without changing your data.
On 12 Nov 2013 09:55, Vinay Saraf vi...@vinaysaraf.com wrote:
You can insert one column which contain sum of all 40 column and you can
use vlookup on that column
On 12 Nov 2013 09:21, Shrinivas Shevde
*where is query?
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Sat, Jul 9, 2011 at 11:37 AM, Venkatesh Srinivas
venkateshs@gmail.com wrote:
please shoot your query
On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP
Hi
Can some one write a macro as per the attach files.
i need a loop fo
On Mon, Jul 11, 2011 at 11:37 AM, ankur ankurpande...@gmail.com wrote:
*where is query?
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On
please shoot your query
On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE
pradeepkumar...@gmail.com wrote:
I have a some query regarding the vlookup can somebody help
--
--
Some important links for excel
check the attachment see if it helps
On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE
pradeepkumar...@gmail.com wrote:
Base file: this file has 3 columns which has
CustomerLE Cost Center
AUG0001 SDFV445858
USA0001 JHNE652147
ZMA0001 NMVE321745
Actual file:
Hey thanks for the formulae, but i want this with a vba code, as i have
send to my customers, i cannot tell them to use formulaes they want
everything in ALT+F8 format
On Sat, Jul 9, 2011 at 12:01 PM, ashish koul koul.ash...@gmail.com wrote:
check the attachment see if it helps
On Sat, Jul
Hey how can i attach sample files, which button to click? as i dont
see any button with browse or attach. please help
On Jul 9, 11:31 am, ashish koul koul.ash...@gmail.com wrote:
check the attachment see if it helps
On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE
Hello,
Can you explain a bit more ?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jai
Envoyé : mercredi 6 juillet 2011 13:07
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Vlookup Query-2
Hello Experts
I
Dear Jai,
Please find solution of 2nd Query...
=VLOOKUP(*C6*,Sheet1!B4:C10,2,0)
See attached sheet.
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Wed, Jul 6, 2011 at 4:37 PM, Jai jaihumtu...@gmail.com wrote:
Hello Experts
I
See if it help
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jai
Sent: Wednesday, July 06, 2011 4:37 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup Query-2
Hello Experts
I Have a one Qurery Please Check the attachment
27 matches
Mail list logo