1.In sheet1 create two colomn as
A B
Child Code Parent Code
2.In Sheet2 create the same columns with data as
Child Code Parent Code
111 Y01
112 Y02
3.Now click cell B1 in sheet 1
4.Insert following formula
=VLOOKUP(B2,Sheet3!A1:B6,2,TRUE)
5.Now drag the cells A and B down to apply the same formula to cells below.

Have a happy time€¦.



Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

Message posted via http://www.officekb.com