Transforming a table into a formula with If function

  • Thread starter Thread starter Bogdan
  • Start date Start date
B

Bogdan

I try to define a formula to reflect the table with "IF" or other functions

NUMBER OF HINGES PER DOOR

DOOR HEIGHT
2400 4 4 4 5 6 6 7 7
2200 4 4 4 5 6 6 7 7
2000 4 4 4 5 5 6 7 7
1800 4 4 4 5 5 6 6 7
1600 4 4 4 4 5 6 6 7
1400 3 3 4 4 5 5 6 7
1200 3 3 4 4 5 5 6 6
1000 3 3 4 4 5 5 6 6
800 2 3 4 4 5 5 6 6
600 2 3 4 4 4 5 6
400 2 3 4 4 4
200 2 3
300 400 500 600 700 800 900 1000 DOOR WIDTH

Thank you very much for your help.
 
With your data table starting in B9, ie the 2400 is in B9, label A1 as WIDTH, A2
as HEIGHT, A3 as HINGES. Then in B1 put say 600, B2 say 1200, and in B3 put the
following:-

=VLOOKUP(B2,B9:J20,MATCH(B1,B21:J21,0),0)

Now just change the values in B1 and B2 to get the various Hinge requirements.
 
Thank you for answering my post.It is intresting for a beginer like
me.
The only thing I would like to have is a math or logical formula to
replace the table(there is no table).EX: we introduce the numbers in
the formula and the resulats to give us the table, if we need one.
Maybe you can help me out.

Thank you in advance
Bogdan
 
What are the criteria for determining how many hinges a door should have? ie how
do you tell from a height and width perspective how many there should be?
 
Back
Top