Is there such a function ?

  • Thread starter Thread starter andreimir
  • Start date Start date
A

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
 
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)

andreimir said:
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


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top