I'm trying to find if there is a formula that will look for a specific value
in one column and return another value from the corresponding position in
another column. I have a list of training participants in column B and I'm
trying to get a summary of those who did not attend as designated by a note
in column H. Ideally, I would like the summary to appear on a different sheet
within the same workbook.
Can you please help?!?!?!?!?

Thanks,
josiecorey