Hi friends ,

I have a challenge in Excel 2007 in Sheet2 range A1:A10 have the names and the B1:B10 have the code aginst the name. in Sheet 1 cell b2 ineed if Cell A1 name is AAA then dorp down codes 01 & 02, if not in AAA name in B2 then want to vlookup the name for code from sheet2 is it possible???


Thanks

LIju