If Statement Question

[Joel Mejia]

How do I write an if statement that writes the following:

I have a status column once I change the status I want to copy that line and paste on the following tab.

It tried this but its only copying one cell.

IF(ISNUMBER(SEARCH("STATUSNAME",NEXTTAB!A2)),NEXTTAB! A2:I2,"")

Thank you all so much for all of your help!

 

[Peter Bartholomew]

Have you written the formula into a range of 9 adjacent cells and committed the formula as an array using Ctrl + Shift + Enter?

 

[Joel Mejia]

No I have not how do I do that. I know I'm terrible at excel. Pardon my dust.

 

[Joel Mejia]

Have you written the formula into a range of 9 adjacent cells and committed the formula as an array using Ctrl + Shift + Enter?

I tried using the array formula function and im getting a ref error...

 

[Joel Mejia]

Have you written the formula into a range of 9 adjacent cells and committed the formula as an array using Ctrl + Shift + Enter?

I got it man im such an idiot! I had the wrong formula copied into cells in the array