help with a formula please
 

Im trying to do a sum(if( statement that is checking multiple criteria
prior to offering its result (then statement).

So, my problem is... how do you write a formula that checks to see if
text is within a range of cells BUT does NOT sum as a result. Instead i
want it to do a vlookup as the result.

Ive tried this but it doesnt work:

=if(a1=z1:z10, vlookup(a1,z1:aa10,2,false),1)

Obviously you cant check to see if a1 is within the range z1:z10 so how
can you accomplish this ?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

help with a formula please
 

=if(countif(a1,z1:z10)0, vlookup(a1,z1:aa10,2,false),1)

--
Regards,
Tom Ogilvy

"scott jeremy" wrote in message
...


Im trying to do a sum(if( statement that is checking multiple criteria
prior to offering its result (then statement).

So, my problem is... how do you write a formula that checks to see if
text is within a range of cells BUT does NOT sum as a result. Instead i
want it to do a vlookup as the result.

Ive tried this but it doesnt work:

=if(a1=z1:z10, vlookup(a1,z1:aa10,2,false),1)

Obviously you cant check to see if a1 is within the range z1:z10 so how
can you accomplish this ?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!