Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP & Data Validation
I have 2 VLOOKUP formulas in one cell that are nested within an IF function. The lookup value is a cell that has a data validation box in it, and the data validation has a fairly "complex" formula in it. The vlookup formula was working but now it suddenly isn't. I thought it may be because I entered a more complicated formula in my data validation cell, but even if I delete the data validation & type in a value the VLOOKUP no longer works. I'm at a loss as to what to do to fix it.
I am new to VLOOKUP & MATCH functions, so I know I must be missing something. You can see named ranges in the formulas below. Please help! Here are my formulas: Formula in the data validation cell: =OFFSET(DeptStart,MATCH($C$76,DeptColumn,0)-1,1,COUNTIF(DeptColumn,$C$76),1) Formula in the VLOOKUP cell: =IFERROR(IF($G$5="Yes",VLOOKUP($F$76,Instructor,4, FALSE),VLOOKUP($F$76,Instructor,3,FALSE)),0) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup and Data Validation Q | Excel Worksheet Functions | |||
Data Validation, VLookup or If ??????? | Excel Discussion (Misc queries) | |||
Vlookup in data validation??? | Excel Worksheet Functions | |||
Data Validation vs VLOOKUP - Linking to data in a seperate file | Excel Worksheet Functions | |||
IF, VLOOKUP & DATA VALIDATION TOGETHER | Excel Worksheet Functions |