Does the formula always go in the same column?

If yes, then the =vlookup(b$2...) portion is always looking at the same cell.

So instead of doing that calculation for each of your formulas, put that
=vlookup() portion in its own cell ($B$3 say).

Then you'll only have to determine that value once:
=VLOOKUP($A3,AllData,VLOOKUP(B$2,Sheet3!$A:$B,2,0) ,0)
becomes
=VLOOKUP($A3,AllData,$b$3,0)


Kim wrote:

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.

--

Dave Peterson