Trying to do a vlookup on a table that is 1000 rows and 26 columns.
If I try to get the value in the 13th column, it works fine. However, if I try for any column greater than that I get a #REF! error. All columns have valid data.
Formula being used is =VLOOKUP($a1,TableSheet!$A:$Z,15,FALSE). Any ideas?
We get a #Ref error if we refer to something that does not exist (e.g.) a named range that has been deleted)
Although your formula looks correct I need to look at a sample file to check the issue
@nabilmourad Thanks for the reply. Turns out there was a duplicate line higher up in the table that was causing the error. Sorry to trouble you.
No problem my friend
Glad you resolved it
Like my reply if you want :)