I would like to see the actual workbook in twbx format with the data
the approach you are using requires an EXACT match (literal) to the text field -
but you are generating nulls - i.e. you have no records that match the Qtype and response combination -
I would test the formula in parts to see what has gone wrong - - e.g test the Qtype against the 2 stings -
if you get a return there - then test the response condition - then rebuild the combination
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.