VLOOKUP

  • Thread starter Thread starter Workbook
  • Start date Start date
W

Workbook

=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.
 
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.
 
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!
 
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.
 
Back
Top