Hello! I am trying to convert a formula that searches filtered data into VBA code and I'm having some trouble with just one portion of the conversion.
The Excel formula is:
=VLOOKUP(G4 & "",IF(SUBTOTAL(3,OFFSET(SomeRange, ROW(SomeRange)-ROW(D2),0,1))>0,AnotherRange),2,0)
My Current VBA...