Dear Experts,
pl suggest any formula which can help me to get valeus for K2 & L2 from raw
sheet against B2 & C2
Note:- kindly Refer the hours which stand within StartTime & EndTime
sheet attached for reference
Thnaks in advance.
rakesh Sharma
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
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
Hi Experts,
How to do vlookup in VBA. i have two sheets saved in different locations.
i need to do vlookup in sheet1 by referring another sheet saved in
different location.
please help.
Thanks & Regards,
Prabhu R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
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 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 E
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
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=
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
; 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
m [mailto:excel-macros@googlegroups.com]
> On Behalf Of Venkatesh Narla
> Sent: 14 May 2012 11:30
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ VLOOKUP HELP NEED
>
> Hi All,
> I need help in Vlookup need formula.
>
> "Hi All,
> Column
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.
Subject: $$Excel-Macros$$ VLOOKUP HELP NEED
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/A
=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
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
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@goog
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
Dear Team,
I am creating macro for Recon of prices where facing problem in multiple
vlookup. Find attached Recon file.
Please any one help me the multiple vlookup function/coding multiple vlookup.
Thanking in Advance.
Regards,
Shrinivas
--
FORUM RULES (986+ members already BANNED for violati
i would like to add an example of what im trying to do. please let me
know how to add a file.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(V
Hi All,
I have a couple of problems :
1.
I wanted to know if there is some short cut for using vlookup multiple times
.
For eg,
I have a table with Name , Phone no ,address..etc in a workbook.
I have a few names from the master list in the second sheet .
Now I want to use vlookup to pull
30 matches
Mail list logo
