vba code for lookup worksheet function

  • Thread starter Thread starter Binoy
  • Start date Start date
B

Binoy

hello,
Any help is welcome.
I would like to write a vba code for looking up for a particular
cell value from a range of cells matching any one row & column, similar
to Combine the Index and Match formulas in Microsoft Excel.
 
you can use index and match in VBA,

Application.Index(Range("A1:Z26"), _
Application.Match(rowval,Range("A1:A26,0), _
Application.Match(colVal, Range("A1:Z1"),0))
 
Back
Top