Hey fzz, you doing well?
I wonder if you could help me generate a VBA code for the following VLOOKUP formula I have in Excel. The target range for this formula is "F22:H417" However, let's select the current range starting at "F22"
Thanks in advance.
=IF(AND($F$5="RAIL BRIDGES",$A20=3),IFERROR(VLOOKUP((F$2&RIGHT($C20,LEN($C20)-6)),'320'!$O$889:$R$4500,4,FALSE),""),"")
Garth Lean
Hey fzz, you doing well?
I wonder if you could help me generate a VBA code for the following VLOOKUP formula I have in Excel. The target range for this formula is "F22:H417" However, let's select the current range starting at "F22"
Thanks in advance.
=IF(AND($F$5="RAIL BRIDGES",$A20=3),IFERROR(VLOOKUP((F$2&RIGHT($C20,LEN($C20)-6)),'320'!$O$889:$R$4500,4,FALSE),""),"")