Help with IF function

Hi all,

I am looking for code advice to get my workbook how I wish.

About my workbook:
I have a two page workbook. 1st sheet is titled "Sign Ups"
Second is "Sponsors"

Sign ups contains the following info
A1 Company Name
B1 Address
C1 City
D1 State
E1 Zipcode
F1 Sponsor (YES or blank for no)

I am wanting to find a code that will take data from Sign Ups (1st sheet) and transfer to Sponsors (second sheet) if I type "YES" in the F1 Sponsor cell. I want not only F1 cell to transfer to the second sheet Sponsor but I want the entire row to transfer so I have all sponsor information on my second sheet Sponsors including Company name, address, city, state, zip, YES

So I have the code:
=IF(FIND("Y",'Sign Ups'!F1)<>0,'Sign Ups'!F1,"")
Which pulls the YES over but I need it to be a range to pull A1:F1 over if YES is typed in F1 cell.

I hope this is clear. Please help. Thank you!

Hi plantexploration, welcome to the forum! Paste this ARRAY FORMULA* in Sponsors!A2 and copy down:

Formula:

=IFERROR(INDEX('Sign Ups'!A$2:A$15,MATCH(1,('Sign Ups'!$F$2:$F$15="Y")*(COUNTIF(Sponsors!A$1:A1,'Sign Ups'!A$2:A$15)=0),0)),"")

Then paste this in B2 and copy across to F2 and down:

Formula:

=IF(Sponsors!$A2="","",VLOOKUP(Sponsors!$A2,'Sign Ups'!$A$2:$F$15,COLUMNS(Sponsors!$A2:B2),FALSE))

*Always press CTRL+SHIFT+ENTER to confirm entry after pasting or editing an ARRAY FORMULA in the Formula Bar.
When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Post #4 Attached File and VLOOKUP formula updated to show blanks correctly.
Thanks for the rep! If complete, please go to Thread Tools up top and mark your thread as SOLVED. Thanks!-Lee