=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