asked on

Recognizing a value instead of the formula

EE Pros,

I have a formula in Cell V70, that reads =If(U70="","",VLOOKUP(C13,$W37:$X41,2FALSE))

Here's the problem. There is a formula in cell U70 that determines either a number or a blank based on another IF Statement in U70:

=IF(B13="","",T70)

If the cell is shows BLANK, although there is a formula calculating the BLANK result in the cell the result produces a #Value! instead of a Blank or Value such as -0-.

How do I get the formula in cell U70 to look at the result of the formula in V70 INSTEAD of producing an error?

B.

Rgonzo1971

HI,

Could you send a dummy?

Regards

Ryan Chong

quick try... use IFERROR to check for a formula error

=IFERROR(  If(U70="","",VLOOKUP(C13,$W37:$X41,2FALSE)) , V70)

Open in new window

IFERROR function
https://support.office.com/en-us/article/IFERROR-function-c526fd07-caeb-47b8-8bb6-63f3e417f611

Bright01

ASKER

Ryan, I was in the middle of putting together an example for Rgonzo when your idea came in. I tested it actually now does not return a #Value result.

One question, if I wanted to add a multiplier onto the formula where would I put it in?

Example;

I want to multiply the result from the VLookup by a number in cell $V$61. Where in this formula would I put that?

=IFERROR( If(U70="","",VLOOKUP(C13,$W37:$X41,2FALSE)) , V70)

Rgonzo1971

pls try

=IFERROR( If(U70="","",VLOOKUP(C13,$W37:$X41,2,FALSE))*$V$61, V70)

ASKER CERTIFIED SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bright01

ASKER

I tried both solutions on adding the additional multiplication. Ryan, your solution worked based on where the parentheses was placed.

Thank you both!

B.