fzz Beginner

  • Member since Dec 22nd 2011
  • Last Activity:
Posts
14
Likes Received
4
Points
46
Trophies
1
Profile Hits
183
  • 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),""),"")