Thanks to Simmon and Linda, too!

Hello everyone,

This is my formulas. All I got is the formulas shows in cell C6 as
type in even though cell B39 list Independent.

=VLOOKUP('Assmt Front'!B39,Tables!D8:E12,2)

*Range is D8:E12 in sheet name Tables.*

01 INDEPENDENT
02 SHARED
03 LIVE-IN PROVIDER
04 LANDLORD/TENANT
05 ROOM & BOARD

Drop down validation list is on cell B39 in sheet name Assmt Front an
my look formulas is in sheet name 293 cell C6.

Did I do somthing wrong?

Regards,
Kim-An

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