[ferget]

примерно так

Код:

cls

function seach ($x){
$File = "D:\1.xlsx"

$Excel = New-Object -ComObject Excel.Application
$xlprocess = Get-Process excel 
$Excel.visible = $false
$Workbook = $Excel.workbooks.open($file)
$Worksheets = $Workbooks.worksheets
$Worksheet = $Workbook.Worksheets.Item(1)

$SearchString = $x

$Range = $Worksheet.Range("A1").EntireColumn
$Search = $Range.find($SearchString)

$a=$Search.Row
$name=$Search.Value()
$data1= $Worksheet.Cells.Item($a,3).Text
$data2= $Worksheet.Cells.Item($a,5).Text
Write-Host "Имя: " $name   "Данное1: " $data1 "Данное2: " $data2
$Excel.quit()
$xlprocess | kill }