Multiple Xlookup or Vlookup help PLEASE!

Hi all, really hoping someone can help with something that I think should be simple....
Attached is sample of the type of spreadsheet I need to use monthly...

Sheet 2 - I need to have a list of customers names and their account handler in column B and C respectively.

Sheet 1 - I need to input monthly data.

I just want the HANDLER column C on sheet 1 to show which (if any handler) is assigned to the customer, using info from sheet 2.
I think I should be using X or V lookup which I am generally ok with doing but I cannot work out how to get it to search the multiple values.

Any help would be so much appreciated!

Am I misunderstanding what you want? Do you want Handler for Customer?


=VLOOKUP($A4,Sheet2!$B$4:$C$10,2,FALSE)

Thank you John
Yes - I input a huge amount of data from another sheet monthly into Sheet 1 which will comprise the customer and the amount paid. I need it to show if there is a handler assigned to that customer in column C sheet 1 straight away to save a lot of searching! Does that make sense? Sheet 2 is my database of customers handlers which I update