Client list

Hello everybody. I'm newbie on the hood.

I have a Clients list and Client's ID list.

Then, I have another list who'll insert client's bill and client's name and finally check my client's ID and insert in another sheet, but if i don't have client's name or client's ID, insert into that cell "I need the ID".

I'll share it. It's an example.

R1 = 3
R2 = 3
R3 = 3
Do While Worksheets("Client's List").Range("C" & R1) > "" 
    If Worksheets("Client's List").Range("C" & R1) = Worksheets("Client's Bills").Range("B" & R2) Then 
        ID= Worksheets("Client's List").Range("B" & R2)  

        Worksheets("Client's Bills").Range("D" & R3) = ID 
        ID = "" 
        R3 = R3 + 1 
        R1 = R1 + 1 
        R2 = 2 
    End If 
    R2 = R2 + 1
Loop

This is my 1st code.

If in "Client's List" doesn't exist the name, it doesn't matter, put then "I need the ID", I don't know if that a correct question.

Because I'm reading a lot of bills, then I paste them and finally check how many bills client have. I didn't think something about formula, I just think, well I'm making with VBA, it'll work if I continues with VBA.

Thanks for the advice and I'll try the formula.

Have a good day.

Hello from Mexico.