vlookup?

[hughsie_10]

Hi clever people,

I'm hoping you can help me with a problem.
As you can see from the attached file, I currently have a data sheet ("Picking Errors Data Sheet" tab) feeding data to a Pivot Table ("Picking Errors (Pick Face) 2014" tab). What I also wanted to do was have a separate sheet collating the totals data for each of the columns from the data sheet between column "MP" and "MISC." for each individual listed in column "B" on the Data Sheet (I have set this up on "Sheet 1" to give a basic idea of what I am looking for). For example, every time a quantity is added against Carolyn Johnson on the data sheet, under MP, I want the formulas on Sheet 1 to add it to the cell in B2 of Sheet 1, likewise if she had entries in BOX for example, it would add them to D2, and so on. I hope I'm making sense!?
Do I have to use some sort of VLOOKUP to do this? What would the formula be? I need it to grow with the columns as I add to the data sheet on the "Picking Errors Data Sheet" tab too.

Can someone help please? Thanks in advance.

[ajryan88]

Hi,

I hope this helps

[hughsie_10]

Hi mate,

Apologies, I don't see anything, what is it you have done please? Is there supposed to be an attachment?

[ajryan88]

Sorry, you're the 3rd person this happened to...there must have been a problem uploading files to the Forum the other day. Give me 5 minutes and I'll attach it to this post

[hughsie_10]

Hello mate, sorry it's taken me so long to get back to you, I've been out of the office. Your formula works perfectly obviously. I didn't even know "INDIRECT" even existed as a formula! Genius my friend, thanks very much for your help, that will save me an awful lot of work each month. Thanks for taking your time to assist me.

[ajryan88]

No problems

Please don't forget to mark this thread as solved by clicking on Thread Tools --> Mark As Solved