How to search for a value in excel, then reference a column to the right of it and grab the value?

[gte]

I need to reference a network share excel spreadsheet, have my script search for a value and then go 2 columns to the right of the value it searched for and grab that value and populate a variable with it?

Anythoughts on how do do that?

I started doing the following, but I'm not sure if I'm headed down the correct path, and I'm not sure how to get it to grab the data out of the array?

#include <Excel.au3>

$sitepoccontactlist = '\\servername\share\folder\folder\folder\file.xls'


$sitepocarray = _ExcelReadSheetToArray($sitepoccontactlist)


;~ _ExcelReadArray($sitepoccontactlist, 1, 2, 0)

$sitepocextracted = _ArraySearch($sitepocarray, $fax_server_name,) 
if @error Then
    MsgBox(0, 'Error', 'Site POC list cannot be loaded for automatic emails')
EndIf

[PsaltyDS]

I need to reference a network share excel spreadsheet, have my script search for a value and then go 2 columns to the right of the value it searched for and grab that value and populate a variable with it?

Anythoughts on how do do that?

I started doing the following, but I'm not sure if I'm headed down the correct path, and I'm not sure how to get it to grab the data out of the array?

#include <Excel.au3>

$sitepoccontactlist = '\\servername\share\folder\folder\folder\file.xls'


$sitepocarray = _ExcelReadSheetToArray($sitepoccontactlist)


;~ _ExcelReadArray($sitepoccontactlist, 1, 2, 0)

$sitepocextracted = _ArraySearch($sitepocarray, $fax_server_name,) 
if @error Then
    MsgBox(0, 'Error', 'Site POC list cannot be loaded for automatic emails')
EndIf

Assuming _ExcelReadSheetToArray() is working for you, the problem is _ArraySearch() which only searches one column at a time on 2D arrays:

#include <Array.au3>

; Create simulated result of _ExcelReadSheetToArray()
Global $avArray[6][6]
$avArray[0][0] = UBound($avArray) - 1; Row count
$avArray[0][1] = UBound($avArray, 2) - 1; Col count
For $r = 1 To $avArray[0][0]
    For $c = 1 To UBound($avArray, 2) - 1
        $avArray[$r][$c] = "R" & $r & "C" & $c; Sim data
    Next
Next
_ArrayDisplay($avArray, "Debug: $avArray")

; Find data in array
For $c = 1 To $avArray[0][1]
    $iFound = _ArraySearch($avArray, "R2C2", 1, 0, 0, 0, 1, $c); Search one column at a time
    If @error Then
        ConsoleWrite("Debug: _ArraySearch() column " & $c & " failed, @error = " & @error & @LF)
    Else
        ConsoleWrite("Debug: Found; row = " & $iFound & ", column = " & $c & @LF)
        ConsoleWrite("Debug: Target data Is at row = " & $iFound & ", column = " & $c + 2 & _
                ", text = " & $avArray[$iFound][$c + 2] & @LF)
        ExitLoop
    EndIf
Next