| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to another worksheet
I have 90 sheet with catalog numbers and pricing. I want to have a main sheet
to enter the catalog number and then in the cell next to it return the cost. =??? (Sheet1!) ?????????? .is there a simple formula that will automaticly return the cost when I put the catalog number into the cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link to another worksheet
Hi,
If you know the sheet name from where you want to pull the information use in let's say cell C3 =+VLOOKUP(B3,Sheet2!$A:$B,2,FALSE) Where B3 is where you enter the catalog #, Sheet2 where you have your catalog, column A where you have the catalog # and column B the cost, If you are not using excel 2007 use =+VLOOKUP(B3,Sheet2!$A$1:$B$1000,2,FALSE) "Old Guy" wrote: I have 90 sheet with catalog numbers and pricing. I want to have a main sheet to enter the catalog number and then in the cell next to it return the cost. =??? (Sheet1!) ?????????? .is there a simple formula that will automaticly return the cost when I put the catalog number into the cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link to another worksheet
Thank you, very much for the information, Eduardo. This helps a lot.
"Eduardo" wrote: Hi, If you know the sheet name from where you want to pull the information use in let's say cell C3 =+VLOOKUP(B3,Sheet2!$A:$B,2,FALSE) Where B3 is where you enter the catalog #, Sheet2 where you have your catalog, column A where you have the catalog # and column B the cost, If you are not using excel 2007 use =+VLOOKUP(B3,Sheet2!$A$1:$B$1000,2,FALSE) "Old Guy" wrote: I have 90 sheet with catalog numbers and pricing. I want to have a main sheet to enter the catalog number and then in the cell next to it return the cost. =??? (Sheet1!) ?????????? .is there a simple formula that will automaticly return the cost when I put the catalog number into the cell? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link to another worksheet
I'm not very good with how formulas work and I don't think I am doing it right.
(main is sheet one) Sheet2 in cell A2 is catalog number, in cell B2 is the cost. This formula should work, right? "Old Guy" wrote: Thank you, very much for the information, Eduardo. This helps a lot. "Eduardo" wrote: Hi, If you know the sheet name from where you want to pull the information use in let's say cell C3 =+VLOOKUP(B3,Sheet2!$A:$B,2,FALSE) Where B3 is where you enter the catalog #, Sheet2 where you have your catalog, column A where you have the catalog # and column B the cost, If you are not using excel 2007 use =+VLOOKUP(B3,Sheet2!$A$1:$B$1000,2,FALSE) "Old Guy" wrote: I have 90 sheet with catalog numbers and pricing. I want to have a main sheet to enter the catalog number and then in the cell next to it return the cost. =??? (Sheet1!) ?????????? .is there a simple formula that will automaticly return the cost when I put the catalog number into the cell? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link to another worksheet
Hi,
The formula is looking at the whole column in sheet2 so in my example you have entered the catalog number in Sheet 1 cell B3, if your information is in cell A3 change the formula from B3 to A3 "Old Guy" wrote: I'm not very good with how formulas work and I don't think I am doing it right. (main is sheet one) Sheet2 in cell A2 is catalog number, in cell B2 is the cost. This formula should work, right? "Old Guy" wrote: Thank you, very much for the information, Eduardo. This helps a lot. "Eduardo" wrote: Hi, If you know the sheet name from where you want to pull the information use in let's say cell C3 =+VLOOKUP(B3,Sheet2!$A:$B,2,FALSE) Where B3 is where you enter the catalog #, Sheet2 where you have your catalog, column A where you have the catalog # and column B the cost, If you are not using excel 2007 use =+VLOOKUP(B3,Sheet2!$A$1:$B$1000,2,FALSE) "Old Guy" wrote: I have 90 sheet with catalog numbers and pricing. I want to have a main sheet to enter the catalog number and then in the cell next to it return the cost. =??? (Sheet1!) ?????????? .is there a simple formula that will automaticly return the cost when I put the catalog number into the cell? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link to another worksheet
Thank you again, I'll give it a try.
"Eduardo" wrote: Hi, The formula is looking at the whole column in sheet2 so in my example you have entered the catalog number in Sheet 1 cell B3, if your information is in cell A3 change the formula from B3 to A3 "Old Guy" wrote: I'm not very good with how formulas work and I don't think I am doing it right. (main is sheet one) Sheet2 in cell A2 is catalog number, in cell B2 is the cost. This formula should work, right? "Old Guy" wrote: Thank you, very much for the information, Eduardo. This helps a lot. "Eduardo" wrote: Hi, If you know the sheet name from where you want to pull the information use in let's say cell C3 =+VLOOKUP(B3,Sheet2!$A:$B,2,FALSE) Where B3 is where you enter the catalog #, Sheet2 where you have your catalog, column A where you have the catalog # and column B the cost, If you are not using excel 2007 use =+VLOOKUP(B3,Sheet2!$A$1:$B$1000,2,FALSE) "Old Guy" wrote: I have 90 sheet with catalog numbers and pricing. I want to have a main sheet to enter the catalog number and then in the cell next to it return the cost. =??? (Sheet1!) ?????????? .is there a simple formula that will automaticly return the cost when I put the catalog number into the cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I link data in an excel worksheet to another worksheet? | Excel Discussion (Misc queries) | |||
| Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions | |||
Linear Mode
