title: Excel - How to add error handling to an array formula using OFFSET
body: <p>I am populating a number of columns based on a lookup using OFFSET and MATCH. I want to add error handling so that the appropriate values are displayed in each of these columns - how can I do this in Excel and in Excel VBA?</p>
  
  <p>Here are the details of the formula that I use:</p>
  
  <p>I enter this formula as an array formula for the entire range B2:E100</p>
  
  <p>=OFFSET(CustomerMaster!$A1,MATCH(A2,customerNumberList,0)-1,2,1,4)</p>
  
  <p>I use the customerNumber in column A2 to fetch a 4 columns related to the customer in another sheet - CustomerMaster. </p>
  
  <p>Now, if there is an error, I want all the 4 cells to have some value like "Unknown". </p>