Question though, lets say I have i insert a row and type into cell B43 "Boom02", Do I have to start type a whole other vlookup all over again or can I just drag the same formula into C43 and D43? I saw that you locked it in with the "$" for B42, so I just have to rewrite the whole vlookup for ano...
Question though, lets say I have i insert a row and type into cell B43 "Boom02", Do I have to start type a whole other vlookup all over again or can I just drag the same formula into C43 and D43? I saw that you locked it in with the "$" for B42, so I just have to rewrite the whole vlookup for ano...