VLOOKUP, something like

=VLOOKUP(Sheet2!A2,my_sheet3_range,2,FALSE)

--

HTH

Bob

"Mezani" wrote in message
...
I am trying to enter data in sheet 1, that is dependant on drop down lists
that are on sheet 2, which is looking through named ranges on sheet 3. Is
lookup the function I want?