Revised IF statement question

[shapenote]

I need to modify the below if statement.

=IFERROR(IF($C2="X", VLOOKUP($A2,Manuals, 2, 0), IF($C2="", VLOOKUP($A2, Kickout, 22, 0))), VLOOKUP($A2, Evaluations, 9, 0))

1) I need to add a criteria to the last part of the statement that says if $C2 is "" and VLOOKUP($A2, Kickout, 22, 0) = "", then do the VLOOKUP($A2, Evaluations, 9, 0).

2) Also, how can I modify the whole formula to never return a 0, but a blank? Currently if any of the cells it is looking up locates a blank space I am getting a 0 return.

 

[rob.barnes01]

I think this will take care of the first part of your problem. I'm unable to test it properly due to your named ranges, though:

=IFERROR(IF($C2="X", VLOOKUP($A2,Manuals, 2, 0), IF($C2="",VLOOKUP($A2, Kickout, 22, 0),IF(AND($C2="",VLOOKUP($A2,Kickout,22,0)=""),VLOOKUP($A2,Evaluations,9,0)))), VLOOKUP($A2, Evaluations, 9, 0))

Hope this helps.

 

[shapenote]

It didn't work. It still returned me a value of 0 instead of going to the last criteria and returning me the value in the Manuals range --- which that range does contain a value.

 

[shapenote]

Basically I am trying to get one of three returns -- in this order of precedence:

#1 -- if the info is on my Manuals tab (range) -- then I want that data

#2 -- if not on Manuals tab (range), look on the Kickout tab (range) and return that data

#3 -- if not on Manuals and not on Kickout (OR it may be on Kickout but blank) then return the data listed on the Evaluations tab (range).

 

[shapenote]

Still could use some help on this issue. Any thoughts on how to get past my formula on the second vlookup if it finds a blank and returns a zero? I need it to move to the three part of the equation where if C2 is blank and the Kickout data range has nothing, then look up on the Evaluations data range.