My appreciation to Bob and Frank!

Drop down list is in Sheet 1, B10. Range is B1:C6.
My formulas is: +VLOOKUP('Sheet1'!B10, B1:C6,2). Could the problem b
because I use same code o1 for House, Condo, and Town House?


*B1* *C6*
01 House
01 Condo
01 Town House
02 Apartment
03 Mobil Home
04 Motel

Regards,
Kim-An

--
Message posted from http://www.ExcelForum.com