Vlookup help please

[DEATHLINX]

hello, i posted yesterday for help on my IF formula and worked great. now i want to move the data that is the lookup to sheet 3 and lock sheet 3 so it cant be messed with and its out of the way. how would i change the folowing formula to reflect this.

=I4-VLOOKUP(H4,$Y$3:$Z$36,2,0)

thank you

 

[VoG]

Maybe

=I4-VLOOKUP(H4,Sheet3!$Y$3:$Z$36,2,0)

 

[DEATHLINX]

i put that formula in and it turns everything to 0 in stead of doing the math and giving me the difference

 

[DEATHLINX]

thank you, i got it to work, i renemaed my sheet and it all worked

thank you