title: How to find the value of a cell adjacent to the current cell C# + Excel
body: <p>I have written a program that finds a cell containing "Customer:" and the program works successfully. The problem is, I want the value of the cell directly next to the cell. The layout looks something like this:</p>
  
  <pre><code>__________   _________
  |Customer:| | Steve  |
  |_________| |________|
  |Customer:| | John   |
  |_________| |________|
  |Customer:| | Frank  |
  |_________| |________|
  </code></pre>
  
  <p>So in this case I would want the values "Steve", "John", and "Frank". How can I do this?</p>
  
  <p>Thanks, Luke</p>
  
  <p>My Code:</p>
  
  <pre><code>public void gatherInfo()
      {
          string temp = "";
  
          Excel.Range currentFind = null;
          Excel.Range firstFind = null;
  
  foreach (Excel.Worksheet sheet in excelWorkbook.Application.Worksheets)
          {
              try
              {
                  // access cell within sheet
                  Excel.Range excelCell =
                        (Excel.Range)sheet.get_Range("A1", Type.Missing);                   
  
                  currentFind = excelCell.Find("Customer:", Type.Missing,
              Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart,
              Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, false,
              Type.Missing, Type.Missing);
  
                  while (currentFind != null)
                  {
                      // Keep track of the first range you find. 
                      if (firstFind == null)
                      {
                          firstFind = currentFind;
                      }
  
                      // If you didn't move to a new range, you are done.
                      else if (currentFind.get_Address(Excel.XlReferenceStyle.xlA1)
                            == firstFind.get_Address(Excel.XlReferenceStyle.xlA1))
                      {
                          //String value of cell
                          temp = currentFind.Value2.ToString();
  
                          break;
                      }
  
                      currentFind = excelCell.FindNext(currentFind);
  
                  }
  
                  //Find adjacent cell value here?
  
                  holdInformation.Add(temp);
  
              }
  
              catch
              {
                  Console.WriteLine("Couldn't get customer name");
              }
  </code></pre>