Using Vlookup to get a value from another worksheet.

[weiner992]

I need to use vlookup from another worksheet that is in column J, and multiply the value by 4.

Thanks.

[Jonmo1]

What issues have you come across that prevents you from doing this?

In other words, you haven't really provided much information to go on.

What value(in which cell) are you looking for?
Which column in the othersheet (and what's that sheet's name) will that value be found?
Which column in the other sheet do you want to return the corresponding value from?

[weiner992]

I want to get the sum of one worksheet and put it into another.

column J in one worksheet multiply by 4 in another worksheet.

[Jonmo1]

Perhaps

=SUM('Other Worksheet'!J:J)*4