Hi
Try
=IF(OR('Sales Order'!I20="Mike",'Sales Order'!I20="Mike & Ray"),'Sales
Order'!B20," ")

--
Regards

Roger Govier


wrote in message
ps.com...
I have a worksheet (Sales Order) that sends data to three other
worksheets. I have an IF statement that sends data based on a pull
down, the formula: =IF('Sales Order'!I20="Mike",'Sales Order'!B20," ")
is located on a worksheet named "Mike Milling" it pulls data from the
Sales order worksheet. Based on criteria from the Sales Order pull
down
data could go to the Mike Milling sheet or to Ray Milling and Mike
Milling. Basically I want to know if I can do something like this:
=IF('Sales Order'!I20="Mike",'Sales Order'!B20," "), OR (IF('Sales
Order'!I20="Mike & Ray",'Sales Order'!B20," ")). I'm trying to get the
data to both worksheets if Mike & Ray is chosen on the Sales Order,
and
to one worksheet if just "Mike" is chosen on the Sales Order.

Any suggestions on how to use 2 IF statements for the same cell?

Thanks,

Chad