if functions dlvv 14.07.2006 16:22:02 I have the following formula in colmun Q =IF(ISNA(Q12(T8,CPT!$B$64:$B$89,FALSE)),"",VLOOKUP(T8,CPT!$B$64:$D$89,3,FALSE)) I also want to add the condition that if in column I the age is less than 50 then return a value of blank. Please help- dlvv

Re: if functions "Bob Phillips" <bob.NGs[ at ]somewhere.com> 14.07.2006 16:43:45 =IF(OR(I8<50,ISNA(Q12(T8,CPT!$B$64:$B$89,FALSE))),"",VLOOKUP(T8,CPT!$B$64:$D $89,3,FALSE)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "dlvv" <dlvv[ at ]discussions.microsoft.com> wrote in message news:837F2167-E469-4543-BE4A-0947A5135FB0[ at ]microsoft.com... [Quoted Text] > I have the following formula in colmun Q > =IF(ISNA(Q12(T8,CPT!$B$64:$B$89,FALSE)),"",VLOOKUP(T8,CPT!$B$64:$D$89,3,FALS E)) > > I also want to add the condition that if in column I the age is less than 50 > then return a value of blank. > > Please help- > > dlvv