vlookup

Copper Contributor

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?

3 Replies

@duglee 

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

@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.

@duglee 

No problem my friend

Glad you resolved it

Like my reply if you want :)

Thanks

Nabil Mourad