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 ...
=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),"")
