Auto fill a row by data from another sheet when i type a cell value

Hi

I have two sheets named , customer data & payment , sheet "customer data" contains whole info about customers. sheet "Payment" contains payment information. I enter payment details in sheet Payment randomly when customers make payment.My customers having a customer id column name "cust id" i want to autofill the corresponding name and phone number(Name (c), Phone no (d)) when i enter "cust id" in payment sheet. i just want to enter "cust id" and "amount" only

i have more than 1000 customers. i have attached a sample file of my sheets . please some one help me

Hi,

One way of achieving what you are after is to use a combination of:-
Named Ranges - based on data in "customer data"
Data Validation - in "payment", cells B2:B18 - select Cust ID from drop-down list
VLookup Formulas - in "payment", cells C2:D18 - auto-populate
Please see attached.
Will this work for you?

Regards

peterrc

Thank you very much Mr. Peterrc
I tried a lot with my original data but i didn't get exact result ,
i am uploading a new file could you please help me to do this task row 2 to row 530.

Expect you will help me
regards
shaibi

Hi,

Please see attached based on my earlier post.
Column A on payment sheet was originally "Date of Payment", now it is Si No ???
Is the attached what you are after?

Regards

peterrc