Hi,
I am trying to combine a vlookup and average if for a range of data based on a table of information based on a differing starting period for the range for each data set.
I started using the below formula:
=VLOOKUP(Site#,Data Range,MATCH(Start week,All time periods)), but it does not average the amounts
Please help
I attached an example of the type of data I am working with
Not only are you asking us to guess the expected answer... you also seem to be asking us to guess the question. For which inputs, what is your expected answer?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
A wild guess. I don't think VLOOKUP is going to help find an average.
Try this in G3 and filled down.I can not discern where the Site# applies though.Formula:
Please Login or Register to view this content.
Can you help us out?
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks