try this
=IF((ISERROR(VLOOKUP(B2,'C:\Users\admin\Downloads\[Master
Sheet.xlsx]Sheet1'!$B:$B,1,0))),"Not Available","Available")
and apply conditional formatting in col a
or
Sub sample()
Dim wkb As Workbook
Dim i As Long
Set wkb = Workbooks.Open("C:\Users\admin\Downloads\Master Sheet.xlsx")
For i
Hi Ashish,
I have attached the sample sheets.
assume Master sheet is saved in D folder. and Consolidated sheet is saved
in E folder
Thanks & Regards,
Prabhu R
On 24 November 2013 13:07, ashish koul wrote:
> share some sample workbooks
>
>
> On Sun, Nov 24, 2013 at 1:06 PM, Prabhu Pinky wrote:
share some sample workbooks
On Sun, Nov 24, 2013 at 1:06 PM, Prabhu Pinky wrote:
> saved in different workbook and in different location. can you help with
> any example sheets.
>
>
> Thanks & Regards,
> Prabhu R
>
>
> On 24 November 2013 12:35, ashish koul wrote:
>
>> saved in different workbo
saved in different workbook and in different location. can you help with
any example sheets.
Thanks & Regards,
Prabhu R
On 24 November 2013 12:35, ashish koul wrote:
> saved in different workbook or in same workbook
>
> you can use application.worksheetfunction.vlookup
>
> MsgBox Application.
saved in different workbook or in same workbook
you can use application.worksheetfunction.vlookup
MsgBox Application.WorksheetFunction.VLookup("4AC", Sheets(2).Range("A:B"),
2, 0)
On Sun, Nov 24, 2013 at 11:32 AM, Prabhu Pinky wrote:
> Hi Experts,
>
> How to do vlookup in VBA. i have two she
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
Find the same ..with useing sumproduct formula.
On Mon, May 6, 2013 at 1:59 PM, priti verma wrote:
> HI Bhanu ,
> please see the attachment.
>
>
> On Mon, May 6, 2013 at 1:35 PM, bhanu prakash wrote:
>
>> Dear All,
>>
>> In Vlookup, when we have more than 3 to 4 return values, how to pick all
>>
HI Bhanu ,
please see the attachment.
On Mon, May 6, 2013 at 1:35 PM, bhanu prakash 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 q
See this.
On Mon, May 6, 2013 at 1:35 PM, bhanu prakash 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
> clear..will ela
Dear Shayam,
Please share a sample sheet.
On Thu, Aug 2, 2012 at 1:45 PM, Anera Shyam 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 show as R, between
I hate loops :(
Sub kTest()
Dim r As Long
With Range("b2:b" & Range("a" & Rows.Count).End(3).Row)
r = .Rows.Count + .Row - 1
.FormulaR1C1 = "=index(r2c[3]:r" & r & "c[3],match(rc[-1],r2c[4]:r"
& r & "c[4],0))"
.Value = .Value
End With
End Sub
Kris
ExcelFox <
earchOrder:=xlByRows, _
> SearchDirection:=xlNext).**Offset(, -1)
> Next
> End Sub
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Venkatesh Narla
> Sent: Monday, May 14, 2012 1:55 PM
> To: exce
osoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Venkatesh Narla
Sent: Monday, May 14, 2012 1:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP HELP NEED
Hi Rajan,
Can i get VBA code for this
Thanks,
Venkatesh.
On Tue, May 15, 201
Hi Rajan,
Can i get VBA code for this
Thanks,
Venkatesh.
On Tue, May 15, 2012 at 12:13 AM, Venkatesh Narla wrote:
> Thanks a lot...
>
> On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma
> wrote:
>> See the attached Solution
>> With
>>
>> Index/Match()
>> Lookup()
>>
>>
>> Regards
>> Rajan verma
Thanks a lot...
On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma wrote:
> See the attached Solution
> With
>
> Index/Match()
> Lookup()
>
>
> Regards
> Rajan verma
> +91 7838100659 [IM-Gtalk]
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
Thanks Aamir.. thanks.
I can write simeple VBA code for this
On Mon, May 14, 2012 at 11:45 PM, Aamir Shahzad
wrote:
> =OFFSET($F$1,MATCH(A2,$F$2:$F$21,0),-1)
>
> Aamir Shahzad
>
> On Mon, May 14, 2012 at 11:00 PM, Venkatesh Narla
> wrote:
>>
>> Hi All,
>> I need help in Vlookup need formula.
See the attached Solution
With
Index/Match()
Lookup()
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkatesh Narla
Sent: 14 May 2012 11:30
To: excel-macros@googlegroups.com
Subje
=OFFSET($F$1,MATCH(A2,$F$2:$F$21,0),-1)
Aamir Shahzad
On Mon, May 14, 2012 at 11:00 PM, Venkatesh Narla wrote:
> Hi All,
> I need help in Vlookup need formula.
>
> "Hi All,
> Column A has data; Column ""F"" is the range need E to pull"
>
>
> 10001 #N/AA 10001
> 10002
: Re: $$Excel-Macros$$ Vlookup Help
Dear Rajan,
Try this...
=IF(C2="EQUITY SHARE",VLOOKUP(A2,'EQUITY
SHARE'!$A$2:$B$17,2,FALSE),IF(C2="DEBENTURE",VLOOKUP(A2,DEBENTURE!$A$2:$B$4,
2,FALSE),IF(C2="MUTUAL FUND",VLOOKUP(A2,'MUTUAL
FUND'!$A$2
Dear Rajan,
Try this...
=IF(C2="EQUITY SHARE",VLOOKUP(A2,'EQUITY
SHARE'!$A$2:$B$17,2,FALSE),IF(C2="DEBENTURE",VLOOKUP(A2,DEBENTURE!$A$2:$B$4,2,FALSE),IF(C2="MUTUAL
FUND",VLOOKUP(A2,'MUTUAL FUND'!$A$2:$B$4,2,FALSE),0)))
Regards
Ashish Bhalara
On Wed, Jan 18, 2012 at 7:58 PM, Rajan_Verma wrote:
See the attached sheet..
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chidurala, Shrinivas
Sent: Jan/Mon/2012 09:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup Help
Dear Team,
I am creating macro for
All your records in Equity, Debentures and Mutual fund are unique. Why
don't you just put everything in one sheet and do a lookup using sumproduct.
Check attached
You can refer to sheets using INDIRECT. However, I wouldn't recommend using
INDIRECT until absolutely necessary.
Regards,
Sam Mathai
22 matches
Mail list logo
