title: lock in a vlookup column
body: <p>so I have the following formula and I'm trying to create a stable formula where $o4$p74 is stapled and wont change. However, I need to constantly delete the p-column and then I do that, the vlookup changes from p to o and continues if I keep deleting the P-column. I'm trying so that it always returns the P-column value in which is always getting deleted, is there any ideas of how to go about this? </p>
  
  <p>=VLOOKUP(B437,BHR8732A2!$O4:$P74,2,FALSE)*$S437</p>