May also want to ask how many items might need to be transferred in total.
Keep in mind the limit of 7 levels of nesting in a formula. If there's going
to be a need for more testing than that, it may be required to look to a VBA
solution.

"dan dungan" wrote:

I would need more specific information, like:

Which spreadsheet holds this formula?
=IF('RFQ Results'!D8="X",'RFQ 1'!D18," ")


Show these specific formulas:

The way the formula is written when I put an "x" beside
line items 1, 4, and 7 on the request for quote they are coppied to
lines 1, 4, and 7 on the purchase order instead of lines 1, 2, and 3
on the purchase
order.