Prev: EXCEL COUNTING HELP
Next: Macro Help
From: T. Valko on 16 Mar 2010 12:07
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Steve" <Steve(a)discussions.microsoft.com> wrote in message
news:40DA3FEB-CB89-43AD-97ED-B408A2D10FA9(a)microsoft.com...
> Worked great. Thank you.
>
> And I do have version 2003.
>
> Steve
>
> "T. Valko" wrote:
>
>> What version of Excel are you using?
>>
>> Try this...
>>
>> =IF(COUNTIF(data!$E$3:$E$16,RU!C3),IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,0)>0,VLOOKUP(RU!C3,data!$E$3:$R$16,2,0),""),"")
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Steve" <Steve(a)discussions.microsoft.com> wrote in message
>> news:C900AB0D-849F-4BA9-8309-5D76657ECA5D(a)microsoft.com...
>> >I have this formula
>> > =IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)>0,(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)),"")
>> >
>> > that is producing #NA if it doesn't find C3. I would instead like the
>> > result
>> > to be blank "" when it produces an #NA
>> >
>> >
>> > Thanks,
>> >
>> > Steve
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: EXCEL COUNTING HELP
Next: Macro Help