I have a fairly convoluted formula but for the problem at hand, it really only concerns the 2nd If statement. =IF(OR($H24="",I$18=""),"",IF(I$18="Additional Notes",IF(ISERROR(MATCH($H24,AdditionalNotes!$H$16:$H445,0)),"", HYPERLINK("#AdditionalNotes!I"&MATCH($H24,AdditionalNotes!$H:$H,0),"Additional Notes")), IF(INDEX(MasterSheet!$B$4:$AG$500,MATCH($H24,MasterSheet!$D$4:$D$500,0), MATCH(I$18,MasterSheet!$B$4:$CF$4,0))=0,"",INDEX(MasterSheet!$B$4:$AG$500, MATCH($H24,MasterSheet!$D$4:$D$500,0), MATCH(I$18,MasterSheet!$B$4:$CF$4,0))))) Basically, if a column contains “Additional notes”, it’ll search a sheet called AdditionalNotes for a name. If that name exists, then I […]
Daily Archives: December 2, 2021
11 posts
I made a batch-file snake game and inserted some special characters via HEX to ANSI conversion in Notepad++. It worked normally. But I noticed that there was an update to the Consolas font and two of the characters became visually the same. Are they: One of them was slightly larger. […]