=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?

=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?

Hi,

the answer depends on which sheet your formula is in:

If the formula is in Sheet2:

=VLOOKUP(Sheet1!B7,C4:D33,2,)
or
=LOOKUP(Sheet1!B7,C4:D33)

If the formula is in Sheet1:

=VLOOKUP(B7,Sheet2!C4:D33,2,)
or
=LOOKUP(B7,Sheet2!C4:D33)

If the formula is in Sheet3:

=VLOOKUP(Sheet1!B7,Sheet2!C4:D33,2,)
or
=LOOKUP(Sheet1!B7,Sheet2!C4:D33)

So as Luke indicated the best way to build formulas is to point and click.
In otherwords start by typing =VLOOKUP( and then click the sheet tab and
then select the cell(s) you want and continue.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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?

Thank you. I was referencing column B (the width was 1) but putting the
contents in Column C, and I couldn't figure out why it wouldn't work when I
was doing it initially. Thanks man for helping me get clarity!

"Luke M" wrote:

=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?

Thank you for the tips, you make some very good points. I appreciatate
you're help. I will make sure to apply what you both have taught me.

"Shane Devenshire" wrote:

Hi,

the answer depends on which sheet your formula is in:

If the formula is in Sheet2:

=VLOOKUP(Sheet1!B7,C4:D33,2,)
or
=LOOKUP(Sheet1!B7,C4:D33)

If the formula is in Sheet1:

=VLOOKUP(B7,Sheet2!C4:D33,2,)
or
=LOOKUP(B7,Sheet2!C4:D33)

If the formula is in Sheet3:

=VLOOKUP(Sheet1!B7,Sheet2!C4:D33,2,)
or
=LOOKUP(Sheet1!B7,Sheet2!C4:D33)

So as Luke indicated the best way to build formulas is to point and click.
In otherwords start by typing =VLOOKUP( and then click the sheet tab and
then select the cell(s) you want and continue.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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?