Dear Seniors,
Thanks for your help, but again i'hve geting same error. querry attached
please find. and help me to crack the query.
I'hve getting wrigh output when i put the formula in Name Column, but when
i paste the same formula in rest of fields like address, process,
salary...!! the
Hi Ashish,
First : Select 4 Rows like : J, K, L, M Paste this formula
*=VLOOKUP(I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
Press Ctrl + Shift + Enter then select J2:M20 **Drag formula like Ctrl
+ D. It's working fine.*
Regards,
Kuldeep Singh
As told by Kuldeep Ji with a small change, which might be causing trouble
for you.
First : Select 4 Rows like : J, K, L, M Paste this formula
*=VLOOKUP(**$**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
Press Ctrl + Shift + Enter then select J2:M20
Dear Seniors,
Formula is working fine.
Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
kanwaljit sir.
Thanks
Ashish
On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
As told by Kuldeep Ji with a small change, which might be causing trouble
for you.
Dear Ashish,
Still Curious to know why do you use Choose here ?
On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Seniors,
Formula is working fine.
Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
kanwaljit sir.
Thanks
Ashish
On
Specially thanks for Noorain Sir (Guru Dev).
Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Tue, Jul 16, 2013 at 7:40
@googlegroups.com
Date: Tue, 16 Jul 2013 19:46:02
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
Dear Ashish,
Still Curious to know why do you use Choose here ?
On Tue, Jul 16, 2013 at 7:40 PM, Ashish
: *Tue, 16 Jul 2013 19:46:02 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
Dear Ashish,
Still Curious to know why do you use Choose here ?
On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar
-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
Dear Sandeep,
Your question is correct, why we are using choose function, because it is
possible through only vlookup Function, no need to using choose Function
: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.
Dear Sandeep,
Your question is correct, why we are using choose function, because it is
possible through only vlookup Function, no need to using choose Function.
But As per Question of Mr. Ashish Kumar, He want to use Choose function
hey plz go through this link for better understanding of using choose with
vlookup..
http://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose
On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Seniors,
kindly find attached vlookup query, I
function?
Thanks in advance.
-- Forwarded message --
From: Prafull Jadhav prafulltjad...@gmail.com
Date: 10 July 2013 16:52
Subject: Re: $$Excel-Macros$$ Vlookup function using with match columns
To: excel-macros@googlegroups.com
Dear Murli,
You can just give ref of column
Dear friends,
Good afternoon,
I need a help and I want to know how to use vlookup function by using match
and columns function. How it is works?
Plz, share with me.
*1.This is using match function*
=vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match
type),*range lookup).
vlookup function?
*Note:* It is more helpful with sharing date by examples.
Thanks in advance.
-- Forwarded message --
From: Muralidhar E emuralidha...@gmail.com
Date: 10 July 2013 15:30
Subject: $$Excel-Macros$$ Vlookup function using with match columns
To: excel-macros
E emuralidha...@gmail.com
Date: 10 July 2013 15:30
Subject: $$Excel-Macros$$ Vlookup function using with match columns
To: excel-macros@googlegroups.com
Dear friends,
Good afternoon,
I need a help and I want to know how to use vlookup function by using
match and columns function. How
get the second value result by using vlookup function?
*Note:* It is more helpful with sharing date by examples.
Thanks in advance.
-- Forwarded message --
From: Muralidhar E emuralidha...@gmail.com
Date: 10 July 2013 15:30
Subject: $$Excel-Macros$$ Vlookup function using
:* It is more helpful with sharing date by examples.
Thanks in advance.
-- Forwarded message --
From: Muralidhar E emuralidha...@gmail.com
Date: 10 July 2013 15:30
Subject: $$Excel-Macros$$ Vlookup function using with match columns
To: excel-macros@googlegroups.com
Dear
, 15 May 2013 16:53:06 +1000
Subject: Re: $$Excel-Macros$$ Vlookup value with comments
From: da...@grugeon.com.au
To: excel-macros@googlegroups.com
It is possible using VBA. Please supply a sample workbook so we can
understand exactly how your data is organised and how you want to look it
up
: Re: $$Excel-Macros$$ Vlookup value with comments
From: da...@grugeon.com.au
To: excel-macros@googlegroups.com
It is possible using VBA. Please supply a sample workbook so we can
understand exactly how your data is organised and how you want to look it
up.
Regards
David Grugeon
On 15
It is possible using VBA. Please supply a sample workbook so we can
understand exactly how your data is organised and how you want to look it
up.
Regards
David Grugeon
On 15 May 2013 13:51, Prabhu Pinky prabhupin...@gmail.com wrote:
Nope. it is not possible..
On 15 May 2013 01:14,
Hi Group,
Is it possible in excel to lookup the comments along with the value.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Nope. it is not possible..
On 15 May 2013 01:14, santosh subudhi santoshkumar.subu...@gmail.comwrote:
Hi Group,
Is it possible in excel to lookup the comments along with the value.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Dear All,
In Vlookup, when we have more than 3 to 4 return values, how to pick all
the return values..in Vlook up it picks the first value .
Need your help at the earliest..let me know if my query is not
clear..will elaborate..thanks
Regards, Bhanu
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
See this.
On Mon, May 6, 2013 at 1:35 PM, bhanu prakash bhanu...@gmail.com wrote:
Dear All,
In Vlookup, when we have more than 3 to 4 return values, how to pick all
the return values..in Vlook up it picks the first value .
Need your help at the earliest..let me know if my query is not
HI Bhanu ,
please see the attachment.
On Mon, May 6, 2013 at 1:35 PM, bhanu prakash bhanu...@gmail.com wrote:
Dear All,
In Vlookup, when we have more than 3 to 4 return values, how to pick all
the return values..in Vlook up it picks the first value .
Need your help at the earliest..let me
Find the same ..with useing sumproduct formula.
On Mon, May 6, 2013 at 1:59 PM, priti verma pritiverma1...@gmail.comwrote:
HI Bhanu ,
please see the attachment.
On Mon, May 6, 2013 at 1:35 PM, bhanu prakash bhanu...@gmail.com wrote:
Dear All,
In Vlookup, when we have more than 3 to 4
Is there any alternative other than array formala?
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of priti verma
Sent: 06 May 2013 14:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Help
Dear
=VLOOKUP(A1,$E$1:$F$17,2,0)
get the result
Alpesh
On Wed, Apr 10, 2013 at 10:04 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear alanthomas,
Put approximate match or exact match then the result will appear.
=vlookup(value,range,columnno,true,false) or
Hi,
You can use below formulas:
*=VLOOKUP($A1,$F$1:$G$17,2,0)
*
*=INDEX($G$1:$G$17,MATCH($A1,$F$1:$F$17,0))
*
*=OFFSET($G1,0,0)*
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please*
I am really confused about the behavior of my VLOOKUP functions in Column 2
of the attached spreadsheet. The function is simply
=VLOOKUP(A1,$E$1:$F$17,2). This is giving me wrong (undefined, or wrong
number) results for some of what I`m looking up. I have not found the
cause or a way around
If you want to look for exact matches, you must use =VLOOKUP(Lookup_Value,
ArrayRangeToLookAt, Column_Index, Whether Approximate Match Or Not)
So try =VLOOKUP(A1,$E$1:$F$17,2,FALSE)
Regards
Sam Mathai Chacko
On Wed, Apr 10, 2013 at 5:51 AM, alanthomas...@gmail.com wrote:
I am really confused
Dear alanthomas,
Put approximate match or exact match then the result will appear.
=vlookup(value,range,columnno,true,false) or
vlookup(value,range,columnno,1,0)
Warm Regards,
Gawli Anil
On Wed, Apr 10, 2013 at 6:43 AM, Sam Mathai Chacko samde...@gmail.comwrote:
If you want to look for
Hello Group,
Is it possible to look up the value in the cell along with the cell
comments or cell colour.
As far I know we can pick the cell colour using Get.cell but not aware
how to us it and I cannot use macros in the file
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you
Yes...
it is possible but using VBA coding
Please check below link for
http://www.pcmag.com/article2/0,2817,2130132,00.asp
.
Enjoy
Team XLS
On Fri, Mar 15, 2013 at 12:52 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hello Group,
Is it possible to
-Macros$$ Vlookup for two same values
To: excel-macros@googlegroups.com
Date: Friday, January 4, 2013, 2:47 PM
I was stuck up with a problem.i have to use vlookup .but in case of two
same values i want distinct values as answer.i.e. if table has two common
values .the vlookup should give
I was stuck up with a problem.i have to use vlookup .but in case of two
same values i want distinct values as answer.i.e. if table has two common
values .the vlookup should give values as separately.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Here is the anwser, I have attached a file with solution. Please reply if you
want this?
--- On Fri, 1/4/13, harshad shukla er.harshad.shu...@gmail.com wrote:
From: harshad shukla er.harshad.shu...@gmail.com
Subject: $$Excel-Macros$$ Vlookup for two same values
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup for two same values
To: excel-macros@googlegroups.com
Date: Friday, January 4, 2013, 2:47 PM
I was stuck up with a problem.i have to use vlookup .but in case of two
same values i want distinct values as answer.i.e. if table has two common
values
, harshad shukla er.harshad.shu...@gmail.com* wrote:
From: harshad shukla er.harshad.shu...@gmail.com
Subject: $$Excel-Macros$$ Vlookup for two same values
To: excel-macros@googlegroups.com
Date: Friday, January 4, 2013, 2:47 PM
I was stuck up with a problem.i have to use vlookup .but in case
Dear Noorain,
Could you please share the Vlookup book if it is prepared at your end?
Best Regards,
Amit
From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
Sent: 02 November 2012 16:46
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Vlookup Book
Dear Noorain,
Are you
the Vlookup book if it is prepared at your end?
** **
Best Regards,
Amit
** **
*From:* Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
*Sent:* 02 November 2012 16:46
*To:* 'excel-macros@googlegroups.com'
*Subject:* RE: $$Excel-Macros$$ Vlookup Book
** **
Dear
Sure... thanks a lot.
Best Regards,
Amit
From: NOORAIN ANSARI [mailto:noorain.ans...@gmail.com]
Sent: 08 November 2012 16:47
To: Amit Desai (MERU)
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Book
Dear Amit,
I am still committed on my words.
But I need some more
October 2012 17:07
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Book
Dear Amit,
Currently i am out of station. Will share it shortly
Sent from BlackBerry(r) on Airtel
From: Amit Desai (MERU)
amit.de
:07
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Book
Dear Amit,
Currently i am out of station. Will share it shortly
Sent from BlackBerry(r) on Airtel
From: Amit Desai (MERU)
amit.de
Dear Noorain,
Few days back you were referring a book to be written on vlookup.
If you have completed, could you please share the same with the Group?
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may
-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup Book
Dear Noorain,
Few days back you were referring a book to be written on vlookup.
If you have completed, could you please share the same with the Group?
Best Regards,
Amit
Disclaimer: This message
Thanks a lot.
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of noorain.ans...@gmail.com
Sent: 29 October 2012 17:07
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Book
Dear Amit,
Currently i am out of station
Hi Amit,
All solution are great and we can also use below mentioned function for for
the same:
=SUMIF(A2:A8,a,B2:B8)
=SUM(SUMIF(A2:A8,{a,b,c},B2:B8))
*Suman Kumar*
On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear All,
** **
I have an
Dear All,
I have an excel file for which, there is Incentive worked out based on 2-3
parameters for the same Technician.
I want to do a vlookup with the total amount (of 2-3 amounts) against that
person. Please help me with a formula.
Best Regards,
Amit
kindly share a sample file with groups,,
Regards,
Gawli Anil
On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear All,
** **
I have an excel file for which, there is Incentive worked out based on 2-3
parameters for the same Technician.
** **
Dear Amit,
I think SUMPRODUCT will better than Vlookup.
Pls share sample sheet for better clarity
On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear All,
** **
I have an excel file for which, there is Incentive worked out based on 2-3
parameters
Please find attached sample data file... I need Vlookup solution not the
Pivoting pls...
Best Regards,
Amit
From: अनिल नारायण गवली [mailto:gawlianil8...@gmail.com]
Sent: 23 October 2012 12:59
To: excel-macros@googlegroups.com; Amit Desai (MERU)
Subject: Re: $$Excel-Macros$$ Vlookup with total
नारायण गवली [mailto:gawlianil8...@gmail.com]
*Sent:* 23 October 2012 12:59
*To:* excel-macros@googlegroups.com; Amit Desai (MERU)
*Subject:* Re: $$Excel-Macros$$ Vlookup with total
** **
kindly share a sample file with groups,,
Regards,
Gawli Anil
On Tue, Oct 23, 2012
-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
*Sent:* 23 October 2012 13:07
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Vlookup with total
** **
Dear Amit,
I think SUMPRODUCT will better than Vlookup.
Pls share sample sheet for better clarity
On Tue
Regards,
Amit
** **
*From:* अनिल नारायण गवली [mailto:gawlianil8...@gmail.com]
*Sent:* 23 October 2012 12:59
*To:* excel-macros@googlegroups.com; Amit Desai (MERU)
*Subject:* Re: $$Excel-Macros$$ Vlookup with total
** **
kindly share a sample file with groups,,
Regards
Thanks a lot.
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 23 October 2012 13:19
To: excel-macros@googlegroups.com
Cc: gawlianil8...@gmail.com
Subject: Re: $$Excel-Macros$$ Vlookup with total
Dear Amit,
Please
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
-
From: amar takale amartak...@gmail.com
To: excel-macros@googlegroups.com
Sent: Mon, September 24, 2012 7:51:28 AM
Subject: $$Excel-Macros$$ Vlookup Required
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
*-
--
*From:* amar takale amartak...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Mon, September 24, 2012 7:51:28 AM
*Subject:* $$Excel-Macros$$ Vlookup Required
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
It is not possible to tell from the file what you want to achieve.
Please describe the problem in the body of your email.
Regards
David Grugeon
On 24 September 2012 21:51, amar takale amartak...@gmail.com wrote:
--
Join official facebook page of this forum @
amartak...@gmail.com
To: excel-macros@googlegroups.com
Sent: Mon, September 24, 2012 8:01:53 AM
Subject: Re: $$Excel-Macros$$ Vlookup Required
Pual Sir,
This is not question.Actually I need Vlookup solution for Data Arrange. So I
post my query for solution to my excel group users.
Regards
Amar
AM
Subject: Re: $$Excel-Macros$$ Vlookup Required
Pual Sir,
This is not question.Actually I need Vlookup solution for Data Arrange. So I
post my query for solution to my excel group users.
Regards
Amar
On Mon, Sep 24, 2012 at 5:23 PM, Paul Schreiner schreiner_p...@att.net
wrote
Hi
I would like to be able to search for a name on a data base and
automatically generate the 3 rows next to it containing the data related to
the original search. For example if I search for PAUL on A1, I would like
to have the the data on B1, B2 and B3 generated automatically on the same
can you share the sample file and output u like to have
On Fri, Aug 10, 2012 at 2:31 PM, Jorge jorgeharleyovie...@gmail.com wrote:
Hi
I would like to be able to search for a name on a data base and
automatically generate the 3 rows next to it containing the data related to
the original
Thanks,
Jorge
On 10 August 2012 10:03, ashish koul koul.ash...@gmail.com wrote:
can you share the sample file and output u like to have
On Fri, Aug 10, 2012 at 2:31 PM, Jorge jorgeharleyovie...@gmail.comwrote:
Hi
I would like to be able to search for a name on a data base and
change the name of VAT to Tax
and try this code in sheet 1 module
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Dim rng As Range
If Target.Column = 8 Then
For Each rng In Target
If rng.Value Then
rng.Offset(0,
Thank you very much!
On 10 August 2012 11:14, ashish koul koul.ash...@gmail.com wrote:
find the attachment too
On Fri, Aug 10, 2012 at 3:43 PM, ashish koul koul.ash...@gmail.comwrote:
change the name of VAT to Tax
and try this code in sheet 1 module
Private Sub Worksheet_Change(ByVal
Why not just the simpler copied across and down
=VLOOKUP($H2,$A$2:$E$10,COLUMN(B2),0)
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Friday, August 10, 2012 5:20 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup
...@gmail.com
*Sent:* Friday, August 10, 2012 5:20 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ vlookup multiple cells
Dear Jorge,
Ashish Solution is nice.
You can also use single vlookup with array
=VLOOKUP(H2,$A$2:$E$10,{2,3,4,5},0)
see attached sheet
Hi All,
I Dont think I have the syntax right..here is what am trying, If the result
of the Lookup is Extended and the subsequent look-up outputs are between
1 to 5 should show as R, between 5 to 7 as Y and 8 as G Or If the Lookup
value is Monthly and the subsequent look-up outputs are 1=R, 2=Y
Dear Shayam,
Please share a sample sheet.
On Thu, Aug 2, 2012 at 1:45 PM, Anera Shyam shyam.utha...@gmail.com wrote:
Hi All,
I Dont think I have the syntax right..here is what am trying, If the
result of the Lookup is Extended and the subsequent look-up outputs are
between 1 to 5 should
Thank you so much for providing such a nice solution.
Thanks again ALL.
On Tue, Jul 17, 2012 at 12:07 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
Do as you like.
2012/7/17 Venkatesh Narla nvenki...@gmail.com
Hi,
Please find the attachment and let me know.. any thing els need..
Hi
I hope this formula will help u
=INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1)
And see the attach file.
Priti
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Hi ,
I hope this will help u
=INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1)
And see the attach file
Priti verma
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Hi Friends,
Please solve my VLookup Query.
Description is given in attached file.
Thanks.
--
With regards,
MaNgEsH
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Thank you much Suman
On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com wrote:
Dear Mangesh,
Please find the attached file as I have learnt this one form Noorain sir
in this group.
On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:
Hi Friends,
Please
so much
On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:
Thank you much Suman
On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com wrote:
Dear Mangesh,
Please find the attached file as I have learnt this one form Noorain sir
in this group.
On Mon, Jul
Dear Mangesh,
You can also use..
*=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)*
or
*=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))*
or
*=OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)*
with ctrl+shift+Enter
See attached sheet.
--
Thanks
Hi Mangesh,
If you want to learn how vlookup works may be below links helps you..
http://www.free-training-tutorial.com/function-vlookup.html
http://spreadsheets.about.com/od/excelfunctions/ss/90320vlookup.htm
Regards,
Lalit Mohan
On Mon, Jul 16, 2012 at 5:27 PM, Mangesh Vimay
Hi,
Please find the attachment and let me know.. any thing els need..
Thanks,
Venkatesh.
On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.com wrote:
Hi Friends,
Please solve my VLookup Query.
Description is given in attached file.
Thanks.
--
With regards,
MaNgEsH
Do as you like.
2012/7/17 Venkatesh Narla nvenki...@gmail.com
Hi,
Please find the attachment and let me know.. any thing els need..
Thanks,
Venkatesh.
On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.com
wrote:
Hi Friends,
Please solve my VLookup Query.
Hi Team,
Can someone please help me with the attached excel sheet.
RegardsSreejith
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Thanks ashish,
But i am getting wrong results for EMP ID : ART1.
RegardsSreejith
From: koul.ash...@gmail.com
Date: Sun, 8 Jul 2012 21:16:11 +0530
Subject: Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise
To: excel-macros@googlegroups.com
=SUMIFS(D:D,A:A,P2,B:B,Q2)
On Sun, Jul 8
: $$Excel-Macros$$ Vlookup or Match formula - regionwise
To: excel-macros@googlegroups.com
=SUMIFS(D:D,A:A,P2,B:B,Q2)
On Sun, Jul 8, 2012 at 8:55 PM, Sreejith K.V itssre...@hotmail.comwrote:
Hi Team,
Can someone please help me with the attached excel sheet.
Regards
Sreejith
--
FORUM
Hi Sreejith,
Since you are looking for a total sales on region wise the attached excel
sheet may solve your problem.
Regards
Santosh
santoshkumar.subu...@gmail.com
--
From: koul.ash...@gmail.com
Date: Sun, 8 Jul 2012 21:16:11 +0530
Subject: Re: $$Excel-Macros
, 2012 at 9:43 PM
Subject: RE: $$Excel-Macros$$ Vlookup or Match formula - regionwise
To: excel-macros excel-macros@googlegroups.com
Hi Sreejith,
Since you are looking for a total sales on region wise the attached excel
sheet may solve your problem.
Regards
Santosh
santoshkumar.subu...@gmail.com
@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
Hi Rajan
Get Total function (UDF) is perfectly fine, but it is taking too much time to
process large data.
Is there any other way to get the same results using Excel in-built functions
like VLOOKUP/ SUMPRODUCT/ INDIRECT. I
=vlookup(I7,$E$7:$F$14,2,1)
On Mon, Jul 2, 2012 at 11:32 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Manoj,
Please more explain..what is your exact requirement.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Mon, Jul 2, 2012 at
Hi,
@Norrrain : I have Attached Xls sheet ,
@Waheed : Thanks
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: Monday, July 02, 2012 11:32 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP for last Available
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ VLOOKUP for last Available Date
** **
Dear Manoj,
Please more explain..what is your exact requirement.
On Mon, Jul 2, 2012 at 11:22 AM, Manoj Kukreja
manoj.kukr...@planetsoft.com wrote:
Hi,
I
=VLOOKUP(I3,$E$2:$F$10,2,TRUE)
On Mon, Jul 2, 2012 at 12:31 PM, Shaik Waheed waheedb...@gmail.com wrote:
=vlookup(I7,$E$7:$F$14,2,1)
On Mon, Jul 2, 2012 at 11:32 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Manoj,
Please more explain..what is your exact requirement.
--
Hi,
I need Vlookup for Last Available Date if the
[cid:image001.png@01CD5845.027B11A0]
This message contains information that may be privileged or confidential and is
the property of PlanetSoft Holdings Inc. It is
intended only for the person to whom it is addressed. If you are not the
:19
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
** **
Thanks Mr. Rajan
** **
For given set of values, its working perfectly. But I have some questions.
** **
1. If values in H5:H9 are changed, then it doesn't give
]
On Behalf Of Amit Gandhi
Sent: 22 June 2012 5:20
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
Hi Experts
I have two Input/Lookup tables, and 1 result table. I want a formula which
can give me desired result instantly. Sample file is attached
Hi Experts
I have two Input/Lookup tables, and 1 result table. I want a formula which
can give me desired result instantly. Sample file is attached for your
ready reference.
How it will be possible? Pls help me here.
Regards
Amit
--
--
FORUM RULES (986+ members already BANNED for violation)
: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
Hi Experts
I have two Input/Lookup tables, and 1 result table. I want a formula which
can give me desired result instantly. Sample file is attached for your ready
reference.
How it will be possible? Pls help me here.
Regards
Amit
@googlegroups.com
*Subject:* $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
** **
Hi Experts
** **
I have two Input/Lookup tables, and 1 result table. I want a formula which
can give me desired result instantly. Sample file is attached for your
ready reference.
** **
How
hi Smitha
i hope this is your requirement
PFA
Regards:
CMA Ankur Pandey
On Mon, Jun 18, 2012 at 11:28 AM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
PFA my vlookup table. If I select the nature of expenses, corresponding
expenses main head should come from the second worksheet anemd
Hi,
PFA my vlookup table. If I select the nature of expenses, corresponding
expenses main head should come from the second worksheet anemd data2.
But the main head coming in the first work sheet is wrong. Please help on
this.
Regards
Smitha
--
FORUM RULES (986+ members already BANNED for
Hi Experts
I want to Lookup PO No. from Lookup data and return all results if there
are multiple occurrences.
How it will be possible? Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
101 - 200 of 427 matches
Mail list logo