Did you mean validation on another sheet, if so use a defined name for your
list
if you meant vlookup refer to the other sheet

=vlookup(lookup_value,'other_sheet'!$A$2:$E$50,3,0 )

will lookup lookup_value in other_sheet A2:A50 and return value from C2:C50

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"kuansheng" wrote in message
oups.com...
How can i use vlookup to reference data on another sheet.