ExcelBanter - lookup?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - lookup? (https://www.excelbanter.com/excel-worksheet-functions/263077-lookup.html)

Mezani

lookup?

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?

Bob Phillips[_4_]

lookup?

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?

All times are GMT +1. The time now is 01:37 PM.