Forum Discussion
VLOOKUP with IF across 2 sheets
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
3 Replies
=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.
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),"")
