View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jitendra Kumar Jitendra Kumar is offline
external usenet poster
 
Posts: 1
Default Refer to a Single cell in a name range

Is anyone there who can help me out?

What is the formula needed to refer a single cell in a named range of cells.
I mean, I want to compare a cells value with any of the cell values in the
named range. let the named range be "holidays"