Thank-you for the response.
Though Vlook-up gives me the answer, but I want to learn new formulas.
Thank-you Nazmul- I will try using Index. Though I have not use it, but it will be interesting to learn something new.
Good day guys !!!
Sheet 2 has data= ID#, first name, last name, child name, amount by each month. All in each individual column.
Sheet 1 has to pull the information. So if ID # is entered in a specific column in sheet 1, The info like First name, last name and each month amount should be able to pull in a...