|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 23rd, 2009, 07:54 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
=VLOOKUP(B7,C4
 33,2,0), how can I modify this so that it works when B7 is on Sheet 1 but C4 33 are on Sheet 2?
|
|
#2
February 23rd, 2009, 08:22 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP
=VLOOKUP('Sheet 1'!B7,'Sheet 2'!C4
33,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 33,2,0), how can I modify this so that it works when B7 is on Sheet 1 but C4 33 are on Sheet 2?
|
|
#3
February 23rd, 2009, 09:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP
Hi,
the answer depends on which sheet your formula is in: If the formula is in Sheet2: =VLOOKUP(Sheet1!B7,C4 33,2,)or =LOOKUP(Sheet1!B7,C4 33)If the formula is in Sheet1: =VLOOKUP(B7,Sheet2!C4 33,2,)or =LOOKUP(B7,Sheet2!C4 33)If the formula is in Sheet3: =VLOOKUP(Sheet1!B7,Sheet2!C4 33,2,)or =LOOKUP(Sheet1!B7,Sheet2!C4 33)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 33,2,0), how can I modify this so that it works when B7 is on Sheet 1 but C4 33 are on Sheet 2?
|
|
#4
February 24th, 2009, 03:33 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP
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 33,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 33,2,0), how can I modify this so that it works when B7 is on Sheet 1 but C4 33 are on Sheet 2?
|
|
#5
February 24th, 2009, 03:35 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP
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 33,2,)or =LOOKUP(Sheet1!B7,C4 33)If the formula is in Sheet1: =VLOOKUP(B7,Sheet2!C4 33,2,)or =LOOKUP(B7,Sheet2!C4 33)If the formula is in Sheet3: =VLOOKUP(Sheet1!B7,Sheet2!C4 33,2,)or =LOOKUP(Sheet1!B7,Sheet2!C4 33)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 33,2,0), how can I modify this so that it works when B7 is on Sheet 1 but C4 33 are on Sheet 2?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
