how to update a sheets based on value of cells in a column in another sheet

I have two sheets on my excel work book. sheet1 contains whole customers data, sheet 2 contains data of customers who made payments. both sheets contain a column named "customer id" , I enter payment details details only in sheets 2 . **i need to get updated sheet 1 automatically based on "customer id" the corresponding row should be highlighted or marked " paid " in another column**.

sheet 1:- all customer data with customer id (1000,999.998.... in descending order)
sheet 2:- details of customers those who made payment with customer id(the order in which the payment made)

Hi

Could you upload a sample of your workbook as it will make it easier to provide a solution for you.

Thanks

Assuming customer ID's are in column A on both sheets, use the following formula to mark "Paid" in your chosen column..

=IF(ISNUMBER(MATCH(A2,'Sheet 2'!$A:$A,0)),"Paid","")

I have uploaded my file

when a customer make payment i enter details in sheet 2 , i need to get updated in sheet 1 column D, in corresponding row (where the customer id found)
pld see the atachment

please see the newly uploaded file , every customer in sheet 1 displays as "paid"

its worked thank you very much