=VLOOKUP(B4,'D:\New Pool Sheet\[Pool League Master.xlsx]Players'!$A$9:$C$120,3,FALSE)

I am using the above expression to return a value used to calculate a score sheet of a pool match. I need this cell to no longer be dynamic once B4 is populated because the results of the match could increase or decrease the value returned. I need a "One Shot" operation.

Thanks in advance for any help with this