just in a message,give an example of the data we would see and the answer you
expect/ want.It doesnt have to be actual data,just an illustration
--
paul
[email protected]
remove nospam for email addy!



"Irv" wrote:

> How do I post an example of the data?..
>
> "paul" wrote:
>
> > perhaps if you post an example of your data and your expected result.I am
> > thinking that the match function used with address,row and colunn will do
> > what you want
> >
> >
> > --
> > paul
> > [email protected]
> > remove nospam for email addy!
> >
> >
> >
> > "Irv" wrote:
> >
> > > Perhaps I didn't explain it clearly.... The result I'm hoping to see is the
> > > location of cell.. Bob Phillips would know what I'm talking about....
> > >
> > > "paul" wrote:
> > >
> > > > i have no idea what youre trying to do!Take a look at the address,row and
> > > > column functions
> > > > --
> > > > paul
> > > > [email protected]
> > > > remove nospam for email addy!
> > > >
> > > >
> > > >
> > > > "Irv" wrote:
> > > >
> > > > > I built a formula but I need it to display the cell reference (column letter
> > > > > & row number), not TRUE or FALSE, of the cell(s) that matches the criterias.
> > > > >
> > > > > I have provided the formula to demonstrate what I'm trying to do.
> > > > >
> > > > > =IF(--($F17="B")--($F17="D")--($F17="RS")*AND($M17="no",$O17="no"),"cell
> > > > > reference")
> > > > >
> > > > > The cell reference should indicate the cell in column "$F" along with the
> > > > > row number.