# 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.
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
HI,

Could you send a dummy?

Regards
Business Systems Analyst , ex-Senior Application EngineerCommented:
quick try... use IFERROR to check for a formula error

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

IFERROR function
https://support.office.com/en-us/article/IFERROR-function-c526fd07-caeb-47b8-8bb6-63f3e417f611
Author Commented:
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)
Commented:
pls try

=IFERROR(  If(U70="","",VLOOKUP(C13,\$W37:\$X41,2,FALSE))*\$V\$61, V70)
Business Systems Analyst , ex-Senior Application EngineerCommented:
try:

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

see if this works?

Experts Exchange Solution brought to you by