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 |
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 |
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 |
All times are GMT +1. The time now is 10:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com