Excel Help! Formula, vlookup, etc..?

Question

Hello Excel Proficients,

I like the result 3C show up in cell when I type in 3 for parts, and 15.5 for load. Then excel reads the table and reads only cells for 3 parts and then compare the amount of load I have. If my load is higher than the allowable for 3C then it should put in 3B and so on. Same thing with 4 parts, and 2 parts and 1 part. If the input load is greater than the maximum (Cap Load) then I like the cell say No Good.

I hope I make sense.

I have tried many ways but I cannot come up with the formula.

Thank you.

I hope I was able to make sense. 
Thank you

Greg G · Accepted Answer

Based on your table, this formula in H8 should work:

=IF(F4=1, "1A", IF(F4=2, "2A/2 S T", IF(F4=3, INDEX(B8:C10, MATCH(F3, C8:C10, -1), 1), INDEX(B4:C7, MATCH(F3, C4:C7, -1), 1))))

IXL@XL · Answer

D3 =IF(VALUE(LEFT(B3,1))=$F$4,$C3,"") copy down list 
H7 =INDEX(B:B,MATCH($F$3,D:D,-1)) result cell 
All other cells as you typed them

Excel Help! Formula, vlookup, etc..?

2 Antworten