Forum Discussion
How to make a cell to reference a range name in vlookup formula
CarlMatDi , your named range is referring to only one column A3 to A500 (=>excel knows about only one column), but you are mentioning 4 in the Vlookup formula , so excel cannot recognize the 4th column, that is why it is returni ng #REF error
For Vlookup to return the value on 4th column starting from column A, your named range should be something like =Movil!$A$3:$D$500
A detail that I didn't mentioned before is that A3 value was filled using a drop down list that I defined using the data validation window.
CarlMatDi , your named range is referring to only one column A3 to A500 (=>excel knows about only one column), but you are mentioning 4 in the Vlookup formula , so excel cannot recognize the 4th column, that is why it is returni ng #REF error
For Vlookup to return the value on 4th column starting from column A, your named range should be something like =Movil!$A$3:$D$500
- Thank you!! That was the issue!
I didn't notice.