| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and Data Validation Q
I am trying to use a DataValidation cell value to do a lookup and I
get #N/a Cell N101 = a Data Validation list value Lookup formula in O101 = =VLOOKUP(N101,Sheet3!A$3:C$248,1,FALSE) Above returns #N/a, but the value I want is in Sheet3!A3 and N101 is in Sheet3!B3 What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in data validation??? | Excel Worksheet Functions | |||
| Data Validation vs VLOOKUP - Linking to data in a seperate file | Excel Worksheet Functions | |||
| Data Validation on Vlookup | Excel Discussion (Misc queries) | |||
| IF, VLOOKUP & DATA VALIDATION TOGETHER | Excel Worksheet Functions | |||
| data validation using vlookup | Excel Worksheet Functions | |||
Threaded Mode
