Duplicate vLookupt entries.

S

snewham

Hi,

I will try to explain this the best that I can using screenshots.


I am creating a go-karting championship spreadsheet for my A-Level
coursework.

This is the part that I am having problems with:
I have created a vLookup formula to display the driver which is
currently sitting within that position.

[image: http://www.4sightracing.com/images/1.jpg]

For example, for 1st place it will search for 1 against the table array
and give me the name of the driver who is sitting within that position.

table array:
[image: http://www.4sightracing.com/images/3.jpg]

However, if one or more drivers are sitting within the same position
like 5 are in this occasion, then it returns the name of the first
driver present but then returns an error message for the other
positions because there is no 9th place but 5 equal 8th places

[image: http://www.4sightracing.com/images/2.jpg]

I was wondering if anyone knew a way that I could overcome this?

Maybe there is a way that I could use an if function if an error is
returned.

Help would be much appreciated

thanks in advance
Scott
 
Top