Jul 12 2019 08:00 AM
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?
Jul 12 2019 08:08 AM
Hi
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
Thanks
Nabil Mourad
Jul 12 2019 08:24 AM
@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.
Jul 12 2019 08:30 AM