I am having some trouble figuring out how to automate the data for the attached file. Basically what I am looking to do:
1) On the end-result sheet, I have a set of unique names going down a column and their work habits across the top row
2) On the datasheet, the data is similarly laid out
3) what I am hoping to achieve is:
a) have the formula look up the name on the end-result sheet,
b) match it to the name on the datasheet
c) then search for their work habits column and if the answer is "yes" place a "1" in the result sheet, otherwise 0
I have tried vlookup, index, match, index, match, match as array and can't seem to figure out where the issue maybe. Please see the attached file, might be easier to understand what I am trying to do.