PDA

View Full Version : [SOLVED] Help with Lookup



rama4672
06-08-2005, 12:14 PM
HI
I have got a file that i need a bit of help with, it collects data week on week and then monthly.
what i need to do is put a lookup formula in the current month that will look at the totals from the previous month and add them to the current month, but it also needs to check the name in the previous month so that they match and it gets the right values, then it adds it to the current month.
At the moment there is a formula that will get the totals, but it needs it to match the same person from the previous month, so if a name is added to the sheet the formula will still pick up the right information.
I have attached a file so it may be a bit clearer if you can see what I mean

Regards

Ian

mdmackillop
06-08-2005, 04:00 PM
Try the following (entered in June sheet only)


=IF(ISNA(VLOOKUP(A7,'May 05'!A:S,19,FALSE)),0+SUM(R7*6)+Q7,VLOOKUP(A7,'May 05'!A:S,19,FALSE)+SUM(R7*6)+Q7)

rama4672
06-09-2005, 01:46 AM
Great
Thanks MD that is just what I wanted.

The next stage now is to do the same kind of information but in Access.

Regards

Ian