not sure what you mean by retrieving information

so if you have a range selected on your main sheet, enter this as a formula
array

=INDIRECT(IF(C6="OFC","Sheet1!A1:C20","Sheet2!D1:F 20"))

if select one of two 20x3 tables depending on the validated cell - in my
example, this is C6

"Kanmi" wrote in message
...
Please how can i use validate dropdown menu data and link to some set of
data
on another worksheet. I have dropdown menu "OFC and DOWNSTRM" I mean when
i
select OFC then it should retrieve information for OFC and when i select
DOWNSTRM then it should retrieve information for DOWNSTRM . Please can
anybody advice on what to do?. Thanks. Appreciate your time.