Return a value based on multiple references in the row

In the attached spreadsheet I have data from survey respondents that is all included in one row for each respondent. So for some data I can simply use a VLOOKUP to find because the value is in one unique column. However, for others I need to find the respondent (column A), then find the question description for that respondent (example is column E), topic matching that question description (example is column F), and actual score matching that question description (example is column H).

I am guessing that I need to use an Index and Match combination but I'm not sure how to structure yet.

Hi and welcome to the forum

You didnt provide much of a sample to work with (1 record?), nor did you supply any examples of what your expected outcome would be? It would be easier to help if you could provide this for us?

Im thinking you may be able to do what you want by using a helper(s) to combine the different bits of info and base the search off that?

index/match syntax is...
=index(range,row,column)

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi. Thanks for the additional info. I will see if some-one can help with this, maybe you need VBA

good luck

1) remove the extra space after "Skill Level" in cell F1.
2) Put this formula in D2 and copy down and across

=INDEX(OFFSET('export (45)'!$A$1, MATCH(Output!$A2, 'export (45)'!$A:$A, 0)-1, , , 50), MATCH($C2&" - "&D$1, OFFSET('export (45)'!$A$1, MATCH(Output!$A2, 'export (45)'!$A:$A, 0)-1, , , 50), 0)+3)

Thanks Jerry