Try

=VLOOKUP('Sheet Name'!K1, $R$1:$W$1050$, 3, false)

Where Sheet Name is the name of the sheet K1 resides on.