Convert to VBA

[antmol89]

Hi guys

Could somebody please help me translate the following function into VBA code:

• =IF(W8<>"UTG_o", INDEX(UTG_o!B3:B171, MATCH(W7, UTG_o!A3:A171, 0)), "")

I want the VBA code to perform in cell V3.

I've tried using the macro recorder and it doesn't quite get the job done.

Really appreciate any help here!

Cheers

 

[Rick Rothstein]

This single line of code should work (simply include it in whatever macro you are developing)...

[table="width: 500"]
[tr]
	[td]Range("V3").Value = [IF(W8<>"UTG_o",INDEX(UTG_o!B3:B171,MATCH(W7,UTG_o!A3:A171,0)),"")][/td]
[/tr]
[/table]

 

[antmol89]

Thank you sooooo much! This worked great!