Creating a formula to input an entire row from another workbook depending on a certai
 

Hi,

I want to create a formula to allow me to input an entire row from another workbook depending on what is inputted in a cell in that workbook eg:

In 'Workbook 1' I would like a formula to input data from 'Workbook 2'. If cell 'C17' in 'Workbook 2' = 12 or 13 then the entire row 17 will be inputed into 'Workbook 1'.

Can I do this?

I hope that makes sense.

Thanks

Andy