Formula to display cell reference (ex.. B7)

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.

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.

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.

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.

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.

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.