View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
krupesh
 
Posts: n/a
Default Finding the value of a cell in an entire worksheet

Hi

You can use this Functions

if(iserror(vlookup(lookup vlaue, lookup in raw data, Column No.,
false)),,"****")
This function is write Zero Where there is no match and put *** where
there is matching value is available.

Regards
Krupesh