IF error

[mojobaabby]

I am using 2007 but everyone i am creating my spreadsheet for is back in the dark ages on 2003. I am using iferror to eliminate a divide #n/a error but it is monkeying with the sheet when they go to use it on an older version. Is there another fix?

this is my formula as it stands now. I need the square footage box to show nothing if nothing entered
thanks in advance

=IFERROR(IF(OR(D6>VLOOKUP(B6,min_max_size!$A$2:$C$18,2,0),E6>VLOOKUP(B6,min_max_size!$A$2:$C$18,3,0)),"2 Big",IF(OR(D6<VLOOKUP(B6,min_max_size!$E$2:$G$18,2,0),E6<VLOOKUP(B6,min_max_size!$E$2:$G$18,3,0)),"2 Small",(D6*E6)/144)),"")

[shg]

Perhaps

=IF(COUNT(D6:E6)<2, "",
IF(OR(D6 > VLOOKUP(B6, $A$2:$C$18, 2), E6 > VLOOKUP(B6, $A$2:$C$18, 3)), "Too Big",
IF(OR(D6 < VLOOKUP(B6, $E$2:$G$18, 2), E6 < VLOOKUP(B6, $E$2:$G$18, 3))," Too Small",
D6*E6/144)))

You need to put the sheet references back. The VLOOKUPs should not require an exact match.

[mojobaabby]

keeps returning too small?
=IF(COUNT(D6:E6)<2, "",
IF(OR(D6 > VLOOKUP(B6,min_max_size!$A$2:$C$18, 2), E6 > VLOOKUP(B6,min_max_size!$A$2:$C$18, 3) ),"Too Big",
IF(OR(D6 < VLOOKUP(B6,min_max_size!$E$2:$G$18, 2), E6 < VLOOKUP(B6,min_max_size!$E$2:$G$18, 3))," Too Small",
D6*E6/144)))

[shg]

Is the data in min_max_size!A2:A18 and E2:E18 is ascending order?

[mojobaabby]

i have attached but i dont see how i can do ascending with these sizes the way they are?

[shg]

All you need to do is sort by size.

Having two tables is redundant.

Please Login or Register  to view this content.

The formula in D20 and copied down is

=IF(ISNA(MATCH(A20, A1:A17, 0)), "Invalid Size",
IF(COUNT(B20:C20)<2, "",
IF(OR(B20 < LOOKUP(A20, $A$2:$B$17), C20 < LOOKUP(A20, $A$2:$D$17)), "Too Small",
IF(OR(B20 > LOOKUP(A20, $A$2:$C$17), C20 > LOOKUP(A20, $A$2:$E$17))," Too Big",
B20*C20/144))))