AVERAGE using LOOKUP, INDEX, or MATCH
Using:
MATCH(B$1,RawData!$1:$1,0)
You're off by 1 column
Either:
MATCH(B$1,RawData!$1:$1,0)-1
Or:
MATCH(B$1,RawData!B$1:IV$1,0)
Thanks for the feedback!
Biff
"DoooWhat" wrote in message
ps.com...
Nevermind. I toyed around with it and got it to work. Thanks for the
quick and effective response!
Kevin
|