VLOOKUP with IF across 2 sheets

[mvaughn88]

Hello, I have a workbook that has multiple sheets.  One of the sheets if named TICKETS.

It has columns A thru J and has 501 rows.  Columns A has unique ticket numbers, the other columns are details for that ticket.  The next sheet in WINNERS, on this sheet columns are C thru L.  Struggling with trying to create a formula that follows the logic below.

On the WINNERS sheet when I enter a winning ticket number in column C. I would like to search column A on the ticket sheet and auto-fill columns with corresponding data.  In my mind I see mapping like this

IF WINNERS Cx = vlookup column A from TICKETS

FILL CELLS FOR THAT ROW AS SUCH

WINNERS Dx = TICKETS (row where the value entred in WINNERS Cx = TICKETS column A

WINNERS Ex = TICKETS 

WINNERS Fx = TICKETS 

WINNERS Gx = TICKETS 

WINNERS Hx = TICKETS

WINNERS Ix = TICKETS

WINNERS Jx = TICKETS

WINNERS Kx = TICKETS

WINNERS Lx = TICKETS

Any help would be great, or if somone has a formula like this they have used

[#2]

@mvaughn88 

=IFERROR(VLOOKUP($C2,TICKETS!$A$2:$J$27,COLUMN(B1),FALSE),"")

Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

Alternatives could be INDEX/MATCH or - if you work with Office365 or 2021 - XLOOKUP. 

[#3]

@OliverScheurich 

Thanks I'lll test that out.  I dug around and got this working too

=IF(NOT(ISBLANK(C3)),VLOOKUP(C3,TICKETS!$A$2:$J$501,2,0),"")

[#4]

@mvaughn88 

another alternative can be
=IF(C2<>"",FILTER(TICKETS!A2:J27,TICKETS!A2:A27=WINNERS!C2,0),"")