Is there such a function ?

[andreimir]

I have a worksheet containing this:

A B C
1 Phone No. Name Comment
2
3
only a few persons having the comment cells non-void,

and another one containing more or less persons with no comments at
all.
Is there a function that could display in the second worksheet only the
non-void comment cells in the 1st worksheet for the same persons and
phone numbers ?

Thank you very much,
Andrei

 

[Bob Phillips]

Andre,

How about this

=IF(NOT(ISBLANK(VLOOKUP("Bob",Sheet1!$A$2:$C$14,3,FALSE))),VLOOKUP("Bob",She
et1!$A$1:$C$14,3,FALSE),"")

Change the value Bob to suit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I have a worksheet containing this:

A B C
1 Phone No. Name Comment
2
3
only a few persons having the comment cells non-void,

and another one containing more or less persons with no comments at
all.
Is there a function that could display in the second worksheet only the
non-void comment cells in the 1st worksheet for the same persons and
phone numbers ?

Thank you very much,
Andrei

creating financial statements