#NA Problem using VLOOKUP

[kingrobbo]

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

 

[Dav]

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
it
or look at

http://www.excelforum.com/showthread.php?t=560172

Regards

Dav