Is there an alternative to vlookup formulas. I have below formulas and trying
to find a way to simplified it.

=VLOOKUP($A3,AllData,VLOOKUP(B$2,Sheet3!$A:$B,2,0) ,0)

I tried DGET but the problem is that it's only good for single row. I have
hundreds of row that use the same formulas.

Thanks.