Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup funtion referenced from another sheet.
Is ther a way to force the Auto Complete to reference another sheet? What i
want to do is have sheet 1, row 1 referece sheet 2, row 1 for the auto complete data. That way I can prevent entry of incorrect data, only leting in what i have listed on the sheet 2. The list function works but you have to pick the data from the list, there must be a way to start entering the data and it would auto fill from the sheet 2 list. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting using lookup up in a different sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Lookup on different sheet | Excel Worksheet Functions | |||
compicated lookup funtion | Excel Discussion (Misc queries) | |||
double lookup, nest, or macro? | Excel Worksheet Functions |