Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookups
I have a table of data that I need to cross reference to get a cell value but
I can't seem to be able to. The table has gate sizes Height and Width with different combinations using different sizes of gate posts e.g. the heights are in the first column and the widths in the first row how would I get the value of say cell B3? -- Regards Warren |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookups
Assuming all heights in column A are unique, and all widths in row 1 are
unique: =OFFSET(A1,MATCH(GateH,A:A,1)-1,MATCH(GateW,1:1,1)-1,1,1) Where GateH is a reference for the heighth of the gate and GateW is the reference to the width of the gate. This is also assuming that your widths begin in column B and on, and heights start in row 2 and on down. -- John C "Warren Easton" wrote: I have a table of data that I need to cross reference to get a cell value but I can't seem to be able to. The table has gate sizes Height and Width with different combinations using different sizes of gate posts e.g. the heights are in the first column and the widths in the first row how would I get the value of say cell B3? -- Regards Warren |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookups
Thanks John this worked perfectly.
-- Regards Warren "John C" wrote: Assuming all heights in column A are unique, and all widths in row 1 are unique: =OFFSET(A1,MATCH(GateH,A:A,1)-1,MATCH(GateW,1:1,1)-1,1,1) Where GateH is a reference for the heighth of the gate and GateW is the reference to the width of the gate. This is also assuming that your widths begin in column B and on, and heights start in row 2 and on down. -- John C "Warren Easton" wrote: I have a table of data that I need to cross reference to get a cell value but I can't seem to be able to. The table has gate sizes Height and Width with different combinations using different sizes of gate posts e.g. the heights are in the first column and the widths in the first row how would I get the value of say cell B3? -- Regards Warren |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two lookups? | Excel Discussion (Misc queries) | |||
Help on lookups | Excel Discussion (Misc queries) | |||
Maybe I need help with Lookups?? | Excel Worksheet Functions | |||
Lookups | Excel Worksheet Functions | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |