Using IFERROR with VLOOKUP

chaz9977

New Member
Joined
Sep 6, 2014
Messages
5
When using this formula I am getting too many arguments .. any help... using excel 2010

=IFERROR(VLOOKUP(RIGHT(M3,7),notes!A:A,1,FALSE),"Failure to process correctly ",IFERROR(VLOOKUP(RIGHT(N3,7,notes!A:A,1,FALSE),"Failure to process correctly"
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Hello,

Welcome to the forums!

You are missing a couple parenthesis, which could cause your problems:


=IFERROR(VLOOKUP(RIGHT(M3,7),notes!A:A,1,FALSE),"Failure to process correctly ",IFERROR(VLOOKUP(RIGHT(N3,7),notes!A:A,1,FALSE),"Failure to process correctly"))


EDIT: Actually, you also have too many arguments. You say If the vlookup returns an error, to return "Failure to process correctly", but then you have another iferror and another vlookup. What are you trying to make happen, because it does have too many arguments.
 
Upvote 0
Hello,






Welcome to the forums!

You are missing a couple parenthesis, which could cause your problems:


=IFERROR(VLOOKUP(RIGHT(M3,7),notes!A:A,1,FALSE),"Failure to process correctly ",IFERROR(VLOOKUP(RIGHT(N3,7),notes!A:A,1,FALSE),"Failure to process correctly"))


EDIT: Actually, you also have too many arguments. You say If the vlookup returns an error, to return "Failure to process correctly", but then you have another iferror and another vlookup. What are you trying to make happen, because it does have too many arguments.


Thank you for reply.
What I'm trying to do is: have M5 and or N5 look in A:A for the valve in M5 an N5 an if it doesn't find the valve to place "failure to process correctly". Hope this helps
 
Upvote 0
Try:

Code:
=IFERROR(VLOOKUP(RIGHT(M3,7),notes!A:A,1,FALSE),IFERROR(VLOOKUP(RIGHT(N3,7),notes!A:A,1,FALSE),"Failure to process correctly"))


EDIT: I think this does what you want, but just to be sure, it will look for M3 first, and if it is in the list of A:A, then it will return the value of M3. If M3 is not found in the list, then it looks for N3 and returns that if found. If neither is found, then it returns "Failure to process correctly".
 
Last edited:
Upvote 0
Thank you so much.. it works good except for when there's nothing in M5 or N5. Can anything be done to show"Failure to process correctly" when this happens?
 
Upvote 0
Hey Chaz,

Sure try:
Code:
=IF(AND(M3="",N3=""),"Failure to process correctly",IFERROR(VLOOKUP(RIGHT(M3,7),notes!A:A,1,FALSE),IFERROR(VLOOKUP(RIGHT(N3,7),notes!A:A,1,FALSE),"Failure to process correctly")))
(Didn't test it yet, I'm on my phone and not on my computer. But essentially put an IF(AND() at the beginning and an extra ) at the end.)
 
Upvote 0
Thank you so much.. it works good except for when there's nothing in M5 or N5. Can anything be done to show"Failure to process correctly" when this happens?

Do you mean (1) nothing in M5 as well as in N5, or (2) nothing in either M5 or N5?
 
Upvote 0
That is correct Aladin.

Sometimes there may not be nothing in M5 ( which means its blank) and or N5 could be blank or it could have the information in it.

I was asking which nothing case do you want additionally cover: 1 or 2? I think case 1 is covered, that is, if both M5 and N5 are empty, the formula would return readily "Failure to process correctly".
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top