Forum Discussion
how to match few criteria and get the result?
hi
Can anyone help on the formulas
I have two sheet, Sheet 1 Attendance and Sheet 2 Workshop attended
How to automate the attendance to match the person email to the workshop and cohort
and indicate Y attended , absent based on the data in sheet 2?
If the person attendance and sheet 2 has a grey Y it should show as Y and a badge icon - replace the current tick Yes
as I need to know if the badge has been awarded to him once it's completed.
Can please advise? I downloaded the template fr excel temp.
Attached file.
Thank you
Your formula XLOOKUP(XLOOKUP)) cannot work. However, it should work with VLOOKUP(XMATCH)).
=IFNA(VLOOKUP($C4,'Sheet 2 Workshop attended'!$B$2:$G$20,XMATCH('Sheet 1 Attendance'!D$3,'Sheet 2 Workshop attended'!$B$1:$G$1)),"")You cannot search for formatting with Lookup. Only the "Y" is ever output.
Does that fit now?
2 Replies
Your formula XLOOKUP(XLOOKUP)) cannot work. However, it should work with VLOOKUP(XMATCH)).
=IFNA(VLOOKUP($C4,'Sheet 2 Workshop attended'!$B$2:$G$20,XMATCH('Sheet 1 Attendance'!D$3,'Sheet 2 Workshop attended'!$B$1:$G$1)),"")You cannot search for formatting with Lookup. Only the "Y" is ever output.
Does that fit now?
- Great. This works. Thank you
|
