Major Function Problems


Posted by Tom in DaBurg on January 18, 2002 5:52 AM

Well my past post had some good responses to it but they were all returning error codes as well, I cut and past a few bits of the puzzle in hopes that we could get this to work.

Here once again is my problem:

I have a function that is working great.
But I now need to have another piece of the puzzle.
I will try to explain, This is my properly working
function:

=IF(ISNA(VLOOKUP(F3,$R$3:$S$11,2)),0,VLOOKUP
(F3,$R$3:$S$11,2))

but what I want to do is add a column which will be column
U#. In the U column is going to be a question with a "yes"
"no" possible answer <list box> I want my above formula
to be the proper formula if the answer in the U column comes back as no &LT;The cell which contains the formula is X#>. if the U column is a yes I want my answer to be the data which the formula will look up in the table so my question is this. How do I do this, I have tried various If and IFerror's to get it to come out and it is not working., My U Column can only return “yes” or “no”.
if it returns yes, I want my cell with this formula
to return the value .35 if the U column returns a no then I want the formula to be executed to return the value from the lookup into the X cell.

without returning any errors such as #N/A

Any help
would be appreciated.

Tom

Posted by Eric B on January 18, 2002 6:18 AM

Not sure I get this- take a look

Hi,
Sorry, low on coffee myself :) and I'm probably missing the boat here. If your vlookup formula is in t2, your "yes/no" is in u2. Do you want a formula in x2 that will return the value of t2 if u2="yes" and .35 if u2="no"? If so then try:
=if(u2="yes",t2,.35)
However, based on the complexity of your previous equations, I have a feeling I'm missing something.

Posted by Aladin Akyurek on January 18, 2002 6:19 AM

Tom --

It seems to me that you did not indicate the relationship (if any) between your lookup values and column U.

Another observation is that your VLOOKUP does not do an exact match, so my question is: What kind of values does F3 (or column F) have?

Aladin

===========



Posted by Eric B on January 18, 2002 6:24 AM

Also, for errors

Also, to control for errors (say u2 does NOT say "yes" or "no") you could:
=if(or(u2="yes",u2="no"),if(u2="yes",t2,.35),"")