Search multiple values, index next column (create a dummy for serch and paste loop)

[Dummy111]

Hello,
I am trying to index values defined by a search from values in a third column.
Tried with vlookup, but it did not work, dont know why. So now am trying with macros.
Here where I got without the loop:

Sub bb()
'
' bb Macro
'

'
Selection.Copy 'THIS IS THE SEARCH VALUE, STARTING AT C1'
ActiveSheet.Range("$A$1:$F$200").AutoFilter Field:=1, Criteria1:="=112265" _ "HERE I LOOK IN A COLUMN FOR THE SAME VALUE'
, Operator:=xlAnd
Selection.Offset(0, 7).Select 'AFTER I FIND THE ROW I NEED, WANT TO COPY THE SAME STARTING VALUE IN THE LAST COLUMN'
ActiveSheet.Paste
'WANT TO LOOP WITH NEXT ROW VALUE TO SEARCH FOR, LIKE C2..3..4'
' WAS PLANING TO IT MANUALY '

End Sub

Any help/advice would be terrific
10x

 

[MrKowz]

Not sure if I exactly follow what you are trying to do. You said VLOOKUP won't work because this is in the third column... have you tried INDEX/MATCH?

 

[Dummy111]

10000x MrKowz

The combination of match and index did the job great.

Thank you for the hint.