About Us

Ok, sent an email.

Biff

"Oceanverd" wrote in message
...
. I could send you the file if need be.

Thanks

Steve

"Biff" wrote:

Hi!

This would require an "eyeball" to see what's going on.

If you want, you can send me the file and I'll have a look. Post back
with a
good email address and I'll contact you.

Biff

"Oceanverd" wrote in message
...
I have been trying to enter scores for our little league one time and
have
it
update the standings and scores pages automatically. I am having
trouble
with the scores in a way that I do a lookup for the date and team name
match
in one worksheet and try to return the score from another when the
match
is
true.

I can get the logic to make the match but when I use the offset command
it
returns the first ocurrance of the team name from my worksheet.

My formula is:

=IF(AND(MATCH($A5,MajorBase!$C$2:$C$251,0),MATCH($ D5,MajorBase!$F$2:$F$251,0)),
OFFSET(MajorBase!$A$1, MATCH($D5, MajorBase!$F$2:$F$166, 0), 6),"")

The A and C columns are the date and team name. When they match the
sheet
I
am in with the raw data sheet it then returns the score of first
ocurrnace
of
the macth.

I realize what this is doing in that it detects that the conditions are
true
and then uses the offset formula to get the value. What I want to do
is
have
the offset function return the value of the corresponding row of the IF
AND
statement.

Any help would be greatly appreciated.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Menu

About Us