Forum Discussion
Pivot tables
I am setting up a budget which I obtained from Nabid Mourad and when trying to use vlookuo to view month name for each month, I get an error '#REF#'. As per Nabid instruction, I have created a 'myli...
jeffjm Would be helpful if you could show the file you are working on and the formula that is returning the #REF! error.
Edit: jeffjm I believe I found the video here:
https://www.youtube.com/watch?v=5ZCBUgkVqqQ
Two minutes into the video, he describes how to create a named range. Ten minutes into the video, he is describing how to create the VLOOKUP function, using the named range as the 'table_array'.
A #REF! error occurs when you try to call for a column index that is beyond the width of the table_array.
Check that the named range "MyList" is indeed 2 columns wide and that the VLOOKUP function calls for the 2nd column.