Finding a match and adding to the statement
I'm using the formula:
=IF(MATCH(C51,'Data Sheet'!A4:A103,1),"Added Holiday(s) For:","")
What I'm wanting to do is to add the information from 'Data Sheet'!B4:B103
to print out after the "Added" statement (the actual name of the holiday
listed). What would be the best way to accomplish this?....Thanks....Ben
|