Re: Duplicate vLookupt entries.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

One way ..

Try this sample file (construct details commented inside):
http://cjoint.com/?ldoT2RKWIa
snewham_gen.xls

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"snewham" <snewham.1xw8cy_1130975101.0175@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:snewham.1xw8cy_1130975101.0175@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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
>
>
> --
> snewham
> ------------------------------------------------------------------------
> snewham's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=28514
> View this thread: http://www.excelforum.com/showthread.php?threadid=481715
>


.

Relevant Pages

  • Duplicate vLookupt entries.
    ... 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. ... driver present but then returns an error message for the other ...
    (microsoft.public.excel)
  • Re: System Information: Error Control
    ... The driver is isapnp.sys is shown as Critical on my system as well as one ... as you will need it later for this step to copy the error message on ... see Help and Support Center at ... Event Source: ...
    (microsoft.public.windowsxp.general)
  • Re: Nv4_disp
    ... Do you have another working monitor you could use to test whether your ... I'm wondering if need to update that graphics driver at all; ... Have a look in the Event Viewer and send us the error messages you ... need it later for this step to copy the error message on it. ...
    (microsoft.public.windowsxp.general)
  • Re: Windows CD cant find my hard drives.
    ... Two of them are in a RAID 0 array. ... To quit setup without installing Windows XP, ... driver floppy, it offered a selection of drivers for the RAID. ...
    (microsoft.public.windowsxp.general)
  • RE: Blue screen of death
    ... A problem has been detected and windows has been shut down to prevent damage ... If a driver in identified in ... Random "0x0000008E" Error Message on a Blue Screen in Windows XP ... View and Manage Event Logs in Event Viewer in Windows XP ...
    (microsoft.public.windowsxp.help_and_support)