So what you are saying is to do it this way:

=IF(MB41!B9:B120=B5,MB41!A9:A120)

What I am wanting is: If the text in MB41 B9 through B120 is the same as B5
then put the text that is in MB41 A9 through A120 into cell A5 with a slash/
in between. Is this correct
--
Thank you,
JR


"EdMac" wrote:


You are approaching the problem the back to front.

What you need is =If(condition1,do this,if not do this).

If you want to meet more than one condition then

=If(and(condition1,condition2,......),do this,if not do this)

Hope this helps

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=508920