Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions |