Google Answers: Another Excel VLOOKUP question

View Question

Q: Another Excel VLOOKUP question ( No Answer, 1 Comment )

Question

Subject: Another Excel VLOOKUP question
Category: Computers > Software
Asked by: brian1973-ga
List Price: $2.00

Posted: 11 Jul 2006 08:04 PDT
Expires: 10 Aug 2006 08:04 PDT
Question ID: 745294

I want to calculate the sum of weekly stats IF the LOOKUP value is the
same as in A8, B8, C8, etc. I came up with
IF(VLOOKUP($A8,Week_1,2,FALSE)=$B8,VLOOKUP($A8,Week_1,COLUMN(C$2),FALSE),0).
If I want the sum of week 1 and week 2, I simply do this
=IF(VLOOKUP($A8,Week_1,2,FALSE)=$B8,VLOOKUP($A8,Week_1,COLUMN(C$2),FALSE),0)+IF(VLOOKUP($A8,Week_2,2,FALSE)=$B8,VLOOKUP($A8,Week_2,COLUMN(C$2),FALSE),0).
Problem is, I need a 52 week sum and the forumla is too long. Any idea
on how I can condense this?

Answer

There is no answer at this time.

Comments

Subject: Re: Another Excel VLOOKUP question
From: jim10007-ga on 02 Aug 2006 16:35 PDT

try using sumif() <= on the week number.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy