View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
roshan roshan is offline
external usenet poster
 
Posts: 4
Default How to find a number from a given data range?

Dear Friends

I need to search the prize list of a scheme for those numbers which I have
with me. I tried the Excel Formulas like "IF", "MATCH", "LOOKUP", "ISNA",
"INDEX", used separately and in different combinations but failed. The above
formulas are only helpful if you search through a single coulmn but for a
range of column data they dont work and always gives error. Please help me.
Thanks.