I am using the following array formula in my Excel 2016 spreadsheet: =arrayformula(if(row(N:N)=1,"FMSS Work Order #",iferror(VLOOKUP(N:N,StandingWorkOrders,{2}*SIGN(ROW(N:N)),false))))
However, due to the inability to manually enter data without interfering with the formula, I would like to convert the formula to a VLOOKUP formula to offer more flexibility. I just don't have enough experience with this type of formula to know how to do this conversion.
Thanks!
