here is your macro bro! Sub test() For i = 2 To 13 ' number of data rows in input array For j = 2 To 8 ' number of data rows in output array If Cells(j, 7) = Cells(i, 1) And Cells(j, 8) >= Cells(i, 2) And Cells(j, 8) <= Cells(i, 3) Then Cells(j, 9) = Cells(i, 4) End If Next j Next i End Sub NOTE: you have to play with i and j values. this module works for the number you have put up in your first post. i'm attaching my excel snapshot. i guess you can go from there. if not email me and i can help. you have to change i, j and column values in IF statement as per the location of your tables. my best advice is try to match your spreadsheet as how i did. :) hope this helps.