Sub addgrp展開1()
    Dim Map As Scripting.Dictionary
    Set Map = New Scripting.Dictionary
   ' Dim info(100, 100) As String
    Dim name As String
    Dim outarr(100, 2) As String
  出力i = 0



  '3列目はサーバ名称
  pol_fullstr = Cells(3, 2).Value
  pol_arr = Split(pol_fullstr, vbLf)
  num_pol_arr = UBound(pol_arr, 1)


For pol_i = 0 To num_pol_arr


'GRP有無検索

 For grp_i = 22 To 23
  If pol_arr(pol_i) = Cells(grp_i, 2).Value Then
    outarr(出力i, 0) = pol_arr(pol_i)
    f_higrp = 1

    member_fullstr = Cells(grp_i, 3).Value
    member_arr = Split(member_fullstr, vbLf)
    num_member_arr = UBound(member_arr, 1)
    'MsgBox num_member_arr
  
    For member_i = 0 To num_member_arr
       outarr(出力i, 0) = pol_arr(pol_i)
       outarr(出力i, 1) = member_arr(member_i)
     '  MsgBox member_arr(member_i)
      '  Range(Cells(12, 2), Cells(18, 3)).Select
       outarr(出力i, 2) = Application.WorksheetFunction.VLookup(member_arr(member_i), Range(Cells(12, 2), Cells(18, 3)), 2, False)
       '   MsgBox outarr(出力i, 2)
        出力i = 出力i + 1
     Next member_i
    End If

 Next grp_i


 If f_higrp = 0 Then
   'add検索
   
    addrip = WorksheetFunction.VLookup(pol_arr(pol_i), Range(Cells(12, 2), Cells(18, 3)), 2, False)
    outarr(出力i, 0) = pol_arr(pol_i)
    outarr(出力i, 1) = pol_arr(pol_i)
    outarr(出力i, 2) = addrip
    MsgBox outarr(出力i, 1)
    出力i = 出力i + 1
  End If
   
  f_higrp = 0

Next pol_i

 outarr_conc_1 = ""

For k = 0 To UBound(outarr, 1)
 outarr_conc_1 = outarr_conc_1 & vbCrLf & outarr(k, 0)
 outarr_conc_2 = outarr_conc_2 & vbCrLf & outarr(k, 1)
 outarr_conc_3 = outarr_conc_3 & vbCrLf & outarr(k, 2)
 MsgBox UBound(outarr, 1)

' Cells(k + 50, 1).Value = outarr(k, 0)
' Cells(k + 50, 2).Value = outarr(k, 1)
' Cells(k + 50, 3).Value = outarr(k, 2)
Next k
  Cells(50, 1).Value = outarr_conc_1
  Cells(50, 2).Value = outarr_conc_2
  Cells(50, 3).Value = outarr_conc_3


End Sub