|Subject:||RE: Excel lookup macro|
|Date:||Tue, 23 May 2006|
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Sheet2!RC[-1]:RC,2,FALSE)"
This does a vlookup from sheet1 and sheet2.
> Does anyone have a simple lookup macro for Excel
Excel lookup macro posted by Lanman6 on Tue, 23 May 2006