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
