View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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