VLOOKUP to different tabs..

[andrewbutler1986]

Good morning all,

This is my very first post and probably not the last

I have a bit of a problem which I hope someone will be able to assist me with?

Basically I have data in 4-5 different tabs which need to pulled through based on a criteria on a front "summary page"

Example is attached.
Any help would be appreciated.

Thanks,

[andrewbutler1986]

Sorry abit more information would probably be needed on this right??

So on the front page someone would put the name of "Andrew Butler" for example. Upon putting the name of Andrew Butler in, this would then go through all the different tabs and count how many lines there are matched upon that criteria.

Example on the "lease" tab there are 4 lines for Andrew Butler so that would count 4, High tab there are 4 lines so that would be 4, Call tab is 4 as well, MIF is 4 and CRM tab has 11 so that would pull through 11.

I know this would be quite complex just wondering if it can be achieved and how?

Thanks!

[AL1976]

Vlookup Help.xlsx
hi,
does the attached file do what you need ?
AL

[andrewbutler1986]

Hi AL,

This looks great so far thanks alot for the help.

One question through, on the CRM Tab there are some other figures which would ideally need to be pulled through, perhaps i different cells under the summary..

So the summary would show:

CRM - MIF = 2365
CRM - Employees = 689

But still based on what the salesman is.

Would this be possible?

Would probably be like a countif somehow with a total for that specific column is that makes sense?

[AL1976]

Vlookup Help.xlsx
here attached, with the 2 other figures.
AL

[andrewbutler1986]

I think you maybe my new hero.

Thank you very much AL. Perfect!

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[andrewbutler1986]

Done and Done.

Thanks Ford.