Forum Discussion
Solved
How to make a cell to reference a range name in vlookup formula
I'm trying to create a vlookup formula that uses a cell reference that contains the name of a cell range. Cell A3 contains the name of a cell range "MOVIL". In cell D3 I entered a 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
Hi and thanks,
but when I changed using INDIRECT a #REF! error resulted:
I'm including the screenshot of the Name Manager.
