Excel Vlookup VBA

Hi,

 

I want to a macro for excel vlookup

 

My current mcaro is:

ActiveCell.FormulaR1C1 = “=VLOOKUP(RC[-86],’2PM’!C[-86]:C[-54],33,0)”

 

I want to select a lookup_value from a specific column eg I4

ActiveCell.FormulaR1C1 = “=VLOOKUP(I4,’2PM’!C[-86]:C[-54],33,0)”

By: Zain

Leave a Reply

Your email address will not be published. Required fields are marked *