ExcelBanter - Excel lookup macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel lookup macro (https://www.excelbanter.com/excel-discussion-misc-queries/90172-excel-lookup-macro.html)

Lanman6

Excel lookup macro

Does anyone have a simple lookup macro for Excel

PDUK1

Excel lookup macro

Hi there

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Sheet2!RC[-1]:R[3]C,2,FALSE)"

This does a vlookup from sheet1 and sheet2.

HTH

Peter
"Lanman6" wrote:

Does anyone have a simple lookup macro for Excel

All times are GMT +1. The time now is 03:29 PM.