In cell A1 i enter a number between 1-40. Now depending on what number is entered will effect the results on my table.
I have a table with 4 headings. Position, Name, Team Name, and Points. Now the cells under the points column is worked out by a VLOOKUP. The VLOOKUP i use is =VLOOKUP(B1,Weeks,7,FALSE) now when i sort this table into numerical order it does not display the correct points and displays #REF! and the VLOOKUP has changed to =VLOOKUP(#REF!,Weeks,7,FALSE)
Why is this? Is any one able to help? If you need anymore info, let me know
I have a table with 4 headings. Position, Name, Team Name, and Points. Now the cells under the points column is worked out by a VLOOKUP. The VLOOKUP i use is =VLOOKUP(B1,Weeks,7,FALSE) now when i sort this table into numerical order it does not display the correct points and displays #REF! and the VLOOKUP has changed to =VLOOKUP(#REF!,Weeks,7,FALSE)
Why is this? Is any one able to help? If you need anymore info, let me know