i am actually able to do it with 4x2=8 nested iferror and vlookup.. but it's very crude and just plain ugly.. and also a pain to adjust for more columns.