Solved: Excel problem

[Spratt_Cary]

I have a Workbook Test2.xls with 2 worksheets: Sheet 1 and Data. WorkSheet "Data" Column A has a list of numbers. If one of those numbers appear on WorkSheet "Sheet 1", column A, then I need for the indication in WorkSheet "Sheet1" Column C to populate on WorkSheet "Data", Column G. Example: Number 13074 appears in WorkSheet "Data", column A from row 519-547. Number 13074 appears on Sheet 1, column A with indication of Hepatic Disorders/Liver - Hepatitis B. This indication "Hepatic Disorders/Liver - Hepatitis B" now needs to populate sheet "Data" on rows 519 to 547. See attached worksheet.

[mbarron]

in the G column of the Data sheet in cell G2 enter:
[VBA]=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$A$267,1,0)),"",VLOOKUP(A2,Sheet1!$A$2:$C$2 67,3,0))[/VBA]
Fill down as far as you need.

[Spratt_Cary]

Man, you guys are so talented. Perfect.