Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello and welcome to JustAnswer~! My name is XXXXX XXXXX I would like to assist you with your question.
You can upload the file to www.mediafire.com and provide the url so we can download it.
I see the example attached never mind.
I'll take a look and get back to you. I'm also going to switch to Q&A so we don't have others jumping on on this. Is that ok?
ok many thanks
Alright, I've got it for you. The formula is based on the "Job Title" so the "Job Title" has to match on the "Matrix Data" sheet and the "Result" sheet. If it does not it will display an error like this "#N/A". I shortened the results to "NDN", "DN", and "NA" so they could fit in the given cell. This can easily be changed in the formula. If you need help or further explanation let me know. Here is the formula and I've linked the sheet you gave me here.
=IF(AND((VLOOKUP(B3,'Matrix Data'!$A$2:$S$12,2,FALSE))="X",'Collected Data'!C3="no"),"DN",IF(AND((VLOOKUP(B3,'Matrix Data'!$A$2:$S$12,2,FALSE))="X",'Collected Data'!C3="yes"),"NDN","NA"))