Hi Brian......
I looked at it again, and it might be that this is what you're after......
=IF(OR($B12=0,$C12=0),"",IF($B12<$O$12,VLOOKUP($C1 2,$K$14:$O$18,4,FALSE),VLOOKUP($C$12,$K$14:$O$18,5 ,FALSE)))
Vaya con Dios,
Chuck, CABGx3
"Brian" wrote:
OK, It is almost there, but one more problem seems to be occurring with this
formula now. Here are the input cells
=IF(OR($B12=0,$C12=0),"",IF($B12<$O$12,VLOOKUP($C1 2,$K$14:$O$18,4,FALSE),""))
B12 C12
4/2/2005 1234
K L M N
O
Poduct Bid 1/1/2005 4/1/2005 (Row12)
Number Material Cost Cost Cost (Row13)
1195 2500/1-1/2" $58.80 $61.00 $64.00 (Row14)
1234 3000/1-1/2" $60.00 $63.00 $66.00 (Row15)
1194 4000/1-1/2" $65.00 $63.25 $66.25 (Row16)
1196 3000/1" $61.00 $64.00 $67.00 (row17)
1194 4000/1" $65.50 $67.00 $70.00 (Row18)
I can't seem to get an answer when the date field matches or exceeds the
"4/1/2005" criteria. All I get is blank! How do I setup the second condition
portion in the formula.
"CLR" wrote:
Try this.........
=IF(OR(B12=0,O12=0),"",IF($B12<$O$12,VLOOKUP(C12,$ K$14:$O$18,4,FALSE),""))
Vaya con Dios,
Chuck, CABGx3
"Brian" wrote in message
...
I used the formula that you provided below and it worked fine except that
it
doesn't really check the first part of the equation, only checks to see if
something is there.
If I have something in field B12 and nothing in C12 my results are blank,
which is correct. If I have nothing in B12 and something in C12, I get an
incorrect answer. I should get the same result "Blank" Any idea why this
happens?
"CLR" wrote:
Maybe.........
=IF(ISNA(IF($B12<$O$12,VLOOKUP(C12,$K$14:$O$18,4,F ALSE))),"",VLOOKUP(C12,$K$
14:$O$18,4,FALSE))
All on one line, watch out for email word-wrap
Vaya con Dios,
Chuck, CABGx3
"Brian" wrote in message
...
I have a VLOOKUP that checks the information of 2 cells against a
table to
determine the proper information to be displayed. It works fine except
when
there is not any information yet placed in the cells. The that #NA
shows
up
when I just want it to be blank. I tried the ISNA, but I think I am
doing
something wrong because I am getting the Error "You Have Entered Too
Many
Arguments For This Function"
Here is my function. What am I doing wrong?
=IF(ISNA($B12<$O$12,VLOOKUP(C12,$K$14:$O$18,4,FALS E)),"",VLOOKUP(C12,$K$14:$
O$18,5,FALSE))
It works fine if I remove the (ISNA and the ),"" piece.
Help me
|