What I am trying to do is look down Col A in Book1 for any matching data then
combine the text from the corresponding cell in ColB and place it into
another Book or cell. Have figured out the combining the text part on its
own, its dealing with variable part at the beging that I am stuck on. I dont
even know which function to use but when I do I WILL get it to work!! As you
can tell I am a novice

=IF(ISNUMBER(MATCH("value",A:A,0)),"value"&INDEX(B :B,MATCH("value",A:A,0)),"
")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Juls" wrote in message
...
What I am trying to do is look down Col A in Book1 for any matching data
then
combine the text from the corresponding cell in ColB and place it into
another Book or cell. Have figured out the combining the text part on its
own, its dealing with variable part at the beging that I am stuck on. I
dont
even know which function to use but when I do I WILL get it to work!! As
you
can tell I am a novice

Thanks for reply Bob, like to say it work but saddly not. I have added in
same range ref but is there anything else I need to do? Although odd shaped
zero/o does appear in the cell where the combined text from Col B should be
is that significant?

"Bob Phillips" wrote:

=IF(ISNUMBER(MATCH("value",A:A,0)),"value"&INDEX(B :B,MATCH("value",A:A,0)),"
")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Juls" wrote in message
...
What I am trying to do is look down Col A in Book1 for any matching data
then
combine the text from the corresponding cell in ColB and place it into
another Book or cell. Have figured out the combining the text part on its
own, its dealing with variable part at the beging that I am stuck on. I
dont
even know which function to use but when I do I WILL get it to work!! As
you
can tell I am a novice

What does your data look like?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Juls" wrote in message
...
Thanks for reply Bob, like to say it work but saddly not. I have added in
same range ref but is there anything else I need to do? Although odd
shaped
zero/o does appear in the cell where the combined text from Col B should
be
is that significant?

"Bob Phillips" wrote:


=IF(ISNUMBER(MATCH("value",A:A,0)),"value"&INDEX(B :B,MATCH("value",A:A,0)),"
")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Juls" wrote in message
...
What I am trying to do is look down Col A in Book1 for any matching
data
then
combine the text from the corresponding cell in ColB and place it into
another Book or cell. Have figured out the combining the text part on
its
own, its dealing with variable part at the beging that I am stuck on.
I
dont
even know which function to use but when I do I WILL get it to work!!
As
you
can tell I am a novice

Bob I hope this explains things better.
What we are dealing with is monthly job sheets (1-12) for one customer
contained in Book1. There is 3 separate identical sections on each sheet
relating to 3 differant staff members, each section is Col A:Y by 25 rows.
Col A contains dates displayed as 1st, 3rd etc. Col B contains a text
description of work carried out. Col C:X contains financial break down of
work carried out. Col Y contains Total in £ of C:X.
E.g

Book 1 (could be any one sheet 1-12)

Col A Col B Col C:X Col Y
2nd aa 5+5 £10
6th bb 2+3+5 £10
17th cc 5+5 £10
-----------------------------------
1st dd 3+2+5 £10
6th ee 4+6 £10
10th ff 2+8 £10
----------------------------------
2nd gg 8+2 £10
6th hh 7+3 £10
17th ii 1+9 £10

I am trying to produce an edited monthly Invoice from the above in Book 2
Sheets 1-12 displayed as below

1st dd 10
2nd aagg 20
6th bbeehh 30
10th ff 10
17th ccii 20
Total £ 90

By the way the zero/0 i mentioned in last post is actualy a square.


"Bob Phillips" wrote:

What does your data look like?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Juls" wrote in message
...
Thanks for reply Bob, like to say it work but saddly not. I have added in
same range ref but is there anything else I need to do? Although odd
shaped
zero/o does appear in the cell where the combined text from Col B should
be
is that significant?

"Bob Phillips" wrote:


=IF(ISNUMBER(MATCH("value",A:A,0)),"value"&INDEX(B :B,MATCH("value",A:A,0)),"
")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Juls" wrote in message
...
What I am trying to do is look down Col A in Book1 for any matching
data
then
combine the text from the corresponding cell in ColB and place it into
another Book or cell. Have figured out the combining the text part on
its
own, its dealing with variable part at the beging that I am stuck on.
I
dont
even know which function to use but when I do I WILL get it to work!!
As
you
can tell I am a novice