Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
What is the VBA equivilate to Excel worksheet function lookup
18 views
Skip to first unread message
John
Dec 4, 2003, 6:03:34 PM12/4/03
to
Hello,
I would like to write code for the following
lookup function.
I would like to write code for the following
lookup function.
=Index(AE31;AJ54,MATCH(L3,AE31;AE54),MATCH(M2,AE31;AJ31,))
Bill Manville
Dec 11, 2003, 7:16:20 PM12/11/03
to
V = [Index(AE31:AJ54,MATCH(L3,AE31:AE54),MATCH(M2,AE31:AJ31,))]
might be considered cheating?
With Range("AE31:AJ54")
V = .Cells(WorksheetFunction.Match(Range("L3"),.Columns(1)), _
WorksheetFunction.Match(Range("M2"),.Rows(1))
End With
is another way.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
0 new messages