View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ben simpson
 
Posts: n/a
Default 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