get corresponding values

[upendrasingh]

i want to automate getting corresponding values in excel.

Ex: if i enter a student's name in column A, i want to get his birthday in column B. The names would be populated, but birth dates would be automated.

i have looked into using macro (VBA). since I am beginner, the codes, and step-by-step directions would help, unless there is an easier way to do this.

thanks!

[NBVC]

When you say birthdays are automated.. you mean they exist in a list somewhere?

If so, then you can use a Vlookup() formula to get that data

e.g. =Vlookup(A1,$X$1:$Y$100,2,FALSE) would look for name that is in A1 and find it in range X1:X100 and return date in B1:B100 at corresponding match point.

[upendrasingh]

thanks a lot! It works!!