=VLOOKUP('Sheet 1'!B7,'Sheet 2'!C4:D33,2,0)

Another handy trick is that when you're building the formula, you can select
another worksheet and cells, and still be 'writing' the formula in your
starting sheet.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Workbook" wrote:

=VLOOKUP(B7,C4:D33,2,0), how can I modify this so that it works when B7 is on
Sheet 1 but C4:D33 are on Sheet 2?