If this = then get cell info from sheet 2

**kirkspam** · 03-22-2010, 01:29 PM

Im trying to write a spreadsheet the will get information from sheet 2 and place it in sheet 1 if it matches the data entered in cell a1
sheet 2 will contain date column a will be the Name and column B will be the Hours
so in sheet 2 you have this
Name HOURS
abc___________1
def ___________1.5
kad___________2

Back in Sheet 1
In column A if I type abc then column b would fill in 1
or if I typed in kad in column coulumn B would = 2

**Palmetto** · 03-22-2010, 03:49 PM

In cell B1 of sheet1and copied down, adjust range references as needed or create a dynamic named range and use it in place of the hard-code range references.

=VLOOKUP(A1,Sheet2!$A$1:$B$10,2,0)