Vlookup and Nested Ifs

[BonnieTheBanker2]

I need to return a value (thinking vlookup here), then if the value is not found, I have a series of nested ifs. How do I combine into one formula?

[TMS]

Use IFERROR

[TMS]

That is

Please Login or Register  to view this content.

[BonnieTheBanker2]

Use IFERROR

Wow - that was easy enough! Now, what formula can be combined with that formula to return either the result of that formula or the best data option/score from a series of similar formulas? I’m assigning a score of A thru D based on three measures (ifs), need to assign only one final score (the best of the three), but replace that with the score from an exception table (vlookup) if present.

[TMS]

If the VLOOKUP doesn't error, that's what you get. If it does, error, you get your nested if formula.

https://support.office.com/en-gb/art...6-63f3e417f611

[TMS]

Sorry, I may have misunderstood your question. Maybe use numeric values rather than alpha and then you could use MAX.

[TMS]

I think you need to mark this solved and follow up the rider in your other (specific) thread on the subject. Otherwise one or the other might be considered a duplicate and closed.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[BonnieTheBanker2]

Sorry, I may have misunderstood your question. Maybe use numeric values rather than alpha and then you could use MAX.

I thought about MAX... Having a final score of A thru D is non-negotiable. I’m looking for a single, clean formula, but perhaps just need to separate. I’m not an Excel ninja - just a forum solution thief! Thanks!

[BonnieTheBanker2]

I think you need to mark this solved and follow up the rider in your other (specific) thread on the subject. Otherwise one or the other might be considered a duplicate and closed.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Do you have suggestions for marking as solved via mobile?