PDA

View Full Version : Solved: Excel problem



Spratt_Cary
01-11-2010, 12:38 PM
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
01-11-2010, 02:53 PM
in the G column of the Data sheet in cell G2 enter:
=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$A$267,1,0)),"",VLOOKUP(A2,Sheet1!$A$2:$C$267,3,0))
Fill down as far as you need.

Spratt_Cary
01-11-2010, 03:26 PM
Man, you guys are so talented. Perfect.