#NA Problem using VLOOKUP



Hi All,

Im currently having an issue using VLOOKUP in that Im trying to get a
football league table to sort automatically.

My problem is that when two teams have the same points value the table
will only display the first team it recognizes will that point value
and display any other teams with that value as #N/A

Can anyone please advise on how to rectify this problem.

(I am new to using formulas etc so please be gentle with me)

Thanks in advance for any assistance





Without seeing the spreadsheet it is difficult to say. An alternative it
to get the table to populate for each team and then create a simple
keystroke macro to sort the table and put this on a button.
Otherwise you need to create a means of spliting the tied results

Perhaps you could provide more details or look at another way of doing
or look at




Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup #NA 4
Using vlookup 6
Problem using Vlookup as a function in VBA. 5
VLOOKUP problem 2
VLOOKUP problem 2
Vlookup Problem 1
Vlookup Problem!? 3
vlookup problem 1