Need help with formula (Previous Value with Criteria)

[JumboCactuar]

Hi,
i currently have the following

Column A: Names
Column B: Values (Current)

Column C: Array (Previous)
example of C11 formula

{=LOOKUP(9.99999999999999E+307,IF($A$2:$A10=A11,IF(ISNUMBER($B$2:$B10),$B$2:$B10)))}

This works to an extent, idea is to lookup every row above the current and output the previous value of the person.

Is there a non array way to do this, since adding this array my sheets have slowed a lot.

much appreciated

 

[JumboCactuar]

Not sure if i can use this style formula somehow

=LOOKUP(2,1/(A2:A10=A11),B2:B10)