View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stunzer Stunzer is offline
external usenet poster
 
Posts: 2
Default Need formula to create a value in a single cell by searching a range

I am attempting to create a value(an error message actually) in a single cell
by "searching" for a given value anywhere in a column or range of cells. The
searched for value in the column is in response(via a formula) to certain
criteria from other values in other cells within same row(using IF, OR, AND
commands).
Does anyone have a fomula that would help me?