Hi

In summary, I have two columns of data as shown:

Col A Col B

1234 1234
4567 1234
8910 8910
4567

For each number in Col A, I need to search the cell address in Col B where it is, then add the
values of the two cells to the right of that address to an array - (offset?).

I will then place the results of that array onto a worksheet. Im not very good with arrays infact
they really confuse me but i appreciate the speed they offer.

My initial attempt is using "Range.find" as shown below, but cant figure how to add this to an array
and then find the next occurrence of the number.


Dim Var() As Variant, FindMe As Range, SearchThis As Range
Dim Found As Range,Dim RngDP As Range, RngBatch As Range, J&, Batch As String, DP As String

With Sheet1
Set FindMe = .Range("G2:G" & .Cells(Rows.Count, 7).End(xlUp).Row)
Set SearchThis = .Range("C1:C" & .Cells(Rows.Count, 3).End(xlUp).Row)

Do Until SearchThis.Value = ""
    
  Set Found = SearchThis.Find(What:=FindMe.Value, After:=SearchThis.Range("A1"), LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False)
  Set RngDP = Found.Offset(0, 2)
  Set RngBatch = Found.Offset(0, 1)
  DP = RngDP.Value
  Batch = RngBatch.Value


Please let me know if any more info is needed.

thanks