I have a table A1:J10 with item labels in column A and months across in row one. Within the table each cell has a value, either "Received" or "Requested".
I'm looking to create a list with a formula that can look up each cell that is still "Requested" and return the Month and item. For...