VLOOKUP - N/A error

Originally Posted by humdingaling

if it is more complex then you need to explain how/why it is going to be more complex as the solution provided may not suit the purpose for your more complex requirements

ah no, no need to worry about it, it'll be my problem how to alter it. No really, if it works for the file attached, then it is indeed what I need.

Originally Posted by humdingaling

any who...solution with VLOOKUP attached ...however...it required extra data input (cell R4)

Uhm... it should start with VLOOKUP, "if statement" can be inside it. But not precede it.
I will try to play around with it. Thanks for the heads up.
Major culprit is the range, it gets messed up. Pretty much sure now that the solution would involve adding new columns that would define the ranges.

Originally Posted by humdingaling

in that regard i attached a solution with LOOKUP that does not require additional data input

Thanks, but this was unnecessary, as I'm saying it for the third time already, I only need the solution with the vlookup function.

Originally Posted by FDibbins

vlookup cannot use non-contiguous ranges like that.

My suspicion has been confirmed:

Originally Posted by dramadeur

Maybe ranges get messed up? (YES/NOs in the column I)

Originally Posted by FDibbins

humdingaling has offered a suggestion that gives you what you need, but it is so involved compared to what you actually need as to be almost (words fail me)

Perhaps, it can be done with vlookup, just additional columns must be added (with certain ranges). I will work on that.