Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying formulas
I copied the following formula to another cell:
=INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B6,LumberSize,0),MATCH('Lumber Gabel Roof'!B18,BoardLength,0)) In the cell I copied the formula to I changed the first Match to cell B7, and the second Match to cell B8. The copied formula with changes results in #NA. B7 and B8 cells are formatted like the cells in the copied formula. =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B7,LumberSize,0),MATCH('Lumber Gabel Roof'!B8,BoardLength,0)) What's going on? Help is appreciated. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying formulas
Are the values you're referring to in B7 and B8 found in the array LumberSize
and BoardLength respectively. Your formula is looking for an exact match, so if it doesn't find one, it'll kick back a #NA error. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Gulfman100" wrote: I copied the following formula to another cell: =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B6,LumberSize,0),MATCH('Lumber Gabel Roof'!B18,BoardLength,0)) In the cell I copied the formula to I changed the first Match to cell B7, and the second Match to cell B8. The copied formula with changes results in #NA. B7 and B8 cells are formatted like the cells in the copied formula. =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B7,LumberSize,0),MATCH('Lumber Gabel Roof'!B8,BoardLength,0)) What's going on? Help is appreciated. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying formulas
I'm not sure what your goal is, but I wonder if you are familiar with
VLOOKUP? Look it up in Excel help and let me know if it seems like I'm barking up the right tree. Then I can answer more questions. I've never used INDEX and MATCH together the way you're presenting them. "Gulfman100" wrote: I copied the following formula to another cell: =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B6,LumberSize,0),MATCH('Lumber Gabel Roof'!B18,BoardLength,0)) In the cell I copied the formula to I changed the first Match to cell B7, and the second Match to cell B8. The copied formula with changes results in #NA. B7 and B8 cells are formatted like the cells in the copied formula. =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B7,LumberSize,0),MATCH('Lumber Gabel Roof'!B8,BoardLength,0)) What's going on? Help is appreciated. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying formulas
:Jon,
I am looking for an exact match in an array named LumberDB, Rows named: LumberSize (2x6, 2x8. 2x10 and 2x12), Columns named: BoardLength (8,10,12,14, etc.). I found the answer to my problem by accident while trying everything I could think of to try. The cell B6 was formatted as TEXT, when I changed it to NUMBER format the formula worked. I am writing a excel program to estimate the cost to build a house. This particular formula searches my data base to return the price of a certain size piece of lumber a certain length. ie. A 2x8 16' long etc. Thanks for your help. "Jon" wrote: I'm not sure what your goal is, but I wonder if you are familiar with VLOOKUP? Look it up in Excel help and let me know if it seems like I'm barking up the right tree. Then I can answer more questions. I've never used INDEX and MATCH together the way you're presenting them. "Gulfman100" wrote: I copied the following formula to another cell: =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B6,LumberSize,0),MATCH('Lumber Gabel Roof'!B18,BoardLength,0)) In the cell I copied the formula to I changed the first Match to cell B7, and the second Match to cell B8. The copied formula with changes results in #NA. B7 and B8 cells are formatted like the cells in the copied formula. =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B7,LumberSize,0),MATCH('Lumber Gabel Roof'!B8,BoardLength,0)) What's going on? Help is appreciated. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying formulas
:Jon,
I am looking for an exact match in an array named LumberDB, Rows named: LumberSize (2x6, 2x8. 2x10 and 2x12), Columns named: BoardLength (8,10,12,14, etc.). I found the answer to my problem by accident while trying everything I could think of to try. The cell B6 was formatted as TEXT, when I changed it to NUMBER format the formula worked. I am writing a excel program to estimate the cost to build a house. This particular formula searches my data base to return the price of a certain size piece of lumber a certain length. ie. A 2x8 16' long etc. Thanks for your help. "Jon" wrote: Click to show or hide original message or reply text. I'm not sure what your goal is, but I wonder if you are familiar with VLOOKUP? Look it up in Excel help and let me know if it seems like I'm barking up the right tree. Then I can answer more questions. I've never used INDEX and MATCH together the way you're presenting them. "Gulfman100" wrote: I copied the following formula to another cell: =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B6,LumberSize,0),MATCH('Lumber Gabel Roof'!B18,BoardLength,0)) In the cell I copied the formula to I changed the first Match to cell B7, and the second Match to cell B8. The copied formula with changes results in #NA. B7 and B8 cells are formatted like the cells in the copied formula. =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B7,LumberSize,0),MATCH('Lumber Gabel Roof'!B8,BoardLength,0)) What's going on? Help is appreciated. "Jon" wrote: I'm not sure what your goal is, but I wonder if you are familiar with VLOOKUP? Look it up in Excel help and let me know if it seems like I'm barking up the right tree. Then I can answer more questions. I've never used INDEX and MATCH together the way you're presenting them. "Gulfman100" wrote: I copied the following formula to another cell: =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B6,LumberSize,0),MATCH('Lumber Gabel Roof'!B18,BoardLength,0)) In the cell I copied the formula to I changed the first Match to cell B7, and the second Match to cell B8. The copied formula with changes results in #NA. B7 and B8 cells are formatted like the cells in the copied formula. =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B7,LumberSize,0),MATCH('Lumber Gabel Roof'!B8,BoardLength,0)) What's going on? Help is appreciated. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying formulas
I am looking for an exact match in an array named LumberDB, Rows named:
LumberSize (2x6, 2x8. 2x10 and 2x12), Columns named: BoardLength (8,10,12,14, etc.). I found the answer to my problem by accident while trying everything I could think of to try. The cell B6 was formatted as TEXT, when I changed it to NUMBER format the formula worked. I am writing a excel program to estimate the cost to build a house. This particular formula searches my data base to return the price of a certain size piece of lumber a certain length. ie. A 2x8 16' long etc. Thanks for the reply. Thanks for your help. "Luke M" wrote: Are the values you're referring to in B7 and B8 found in the array LumberSize and BoardLength respectively. Your formula is looking for an exact match, so if it doesn't find one, it'll kick back a #NA error. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Gulfman100" wrote: I copied the following formula to another cell: =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B6,LumberSize,0),MATCH('Lumber Gabel Roof'!B18,BoardLength,0)) In the cell I copied the formula to I changed the first Match to cell B7, and the second Match to cell B8. The copied formula with changes results in #NA. B7 and B8 cells are formatted like the cells in the copied formula. =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B7,LumberSize,0),MATCH('Lumber Gabel Roof'!B8,BoardLength,0)) What's going on? Help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help copying formulas | Excel Discussion (Misc queries) | |||
Copying formulas | New Users to Excel | |||
copying formulas | Excel Discussion (Misc queries) | |||
Copying formulas | Excel Discussion (Misc queries) | |||
Copying Formulas PLEASE HELP THANK YOU | Excel Discussion (Misc queries) |