Hello, I am trying have my spreadsheet compare two columns and if the data matches than in another column enter a checkmark if a cell contains a specific value.
On my spreadsheet, "student worker list" will have a list of students that are assigned a number. I want a formula in "student worker list" in the L column to look at "student worker pay" to search column A for the matching number and then if Cell E has the word "August" to enter a checkmark in the corresponding L cell. "Student worker pay" may have the number listed more than once, because every month when they submit their timesheet, it will show, just the month changes. So I would duplicate this formula in "student worker list" in K through V with the appropriate month.
TO simplifiy, I just want a checkmark in column K thru V if that particular student submitted their timesheet for that month based on the data in "student worker pay" . So K = June, L = August, M = September, etc.
Any suggestions.
13-14 budget.xlsm
Bookmarks