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
|