No I didn't, I used ,0 because I was expecting an exact match. That is why I
adjust today's date to get that exact match.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Gareth - Network analyst."
wrote in message ...
BWAHAHAHAHAHA I got it hahahahahahaha :D

=INDEX('2nd Line Schedule'!B2:J2,MATCH(C4,INDEX('2nd Line
Schedule'!B3:J39,MATCH(TODAY()-WEEKDAY(TODAY(),2)+1,'2nd Line
Schedule'!A3:A39,1),0),0))

Lol you forgot a 1 :D

=INDEX('2nd Line Schedule'!B2:J2,MATCH(C4,INDEX('2nd Line
Schedule'!B3:J39,MATCH(TODAY()-WEEKDAY(TODAY(),2)+1,'2nd Line
Schedule'!A3:A39,0),0),0))

Ah the days of machine code finally payed off BWAHAHAHAHAHAHAHAHAHAHA

Thanks alot Bob for all of the assist and for all the assist you were
willing to give me here. I'm sure your just as annoyed with this bit of
code
as i am now lol

Thanks again :D

"Bob Phillips" wrote:

I can't mail you because you are on the web group, but you should be able
to
work my email out from my signature.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Gareth - Network analyst."

wrote in message
...
Ok this still aint working, Can you mail me cause i see your Mail
address
not
listed, then i can mail the doc to you to check maybe it will work
better
if
you can actually see whats happening, maybe im doing something wrong
still
or
you getting wrong locations for formula.?
Then we can just post the working formula here lol

"Bob Phillips" wrote:

Hopefully this is better

=INDEX('2nd Line Schedule'!B2:J2,MATCH(C4,INDEX('2nd Line
Schedule'!B3:J39,MATCH(TODAY()-WEEKDAY(TODAY(),2)+1,'2nd Line
Schedule'!A3:A39,0),0),0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Gareth - Network analyst."

wrote in message
...
OK if i take it all and copythe hole thing as is with my values and
CRTL-SHIFT-Enter then it keeps returning the 8th value "H"

dunno what im doing wrong here, if i user the Match and index i get
everything i want if i tell it what columb to return the value from

"Bob Phillips" wrote:

did you array enter it?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in
my
addy)

"Gareth - Network analyst."

wrote in message
...
OK Great I follow that BUT...

thats fine for returning the value In a known column yes :D

Now I want it to find in that row the name I enter in Cell C4
getting a
column number then using that column number in B2:J2 and return
the
Cell
value there.

I tried adapting your other code but it gives the wrong value.

=INDEX('2nd Line Schedule'!B2:J2,MIN(IF(('2nd Line
Schedule'!A3:A39=TODAY()-WEEKDAY(TODAY(),2)+1)*('2nd Line
Schedule'!B2:J39=C4),ROW('2nd Line Schedule'!A3:A39)-MIN(ROW('2nd
Line
Schedule'!A3:A39))+1)))

it continually returns the second columbs value even if i change
the
value
in C4