S
scott jeremy
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 ?
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 ?