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