vlookup with multiple results

AceFI

Board Regular
Joined
Apr 20, 2012
Messages
91
Hi all,
i'm sure this has been done to death... but can't seem to find an answer...

i have a 'prospect database' that has about 2500 results in it, for a variety of employees.. some prostects are 'dead' some not.
Daily, i'm wanting to on a separate sheet, list all of the 'current' prospects, and also on the same sheet return '12 month follow up' prospects

I can do this no problem - as long as there is only 1 result...

any ideas / suggestions on this?
The lead database is numerically sequential

thanks :)
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
come to think of it.. it will need to be index and match not vlookup because of the ordr of detail
 
Upvote 0
Excel 2016 (Mac) 64 bit


A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
1
#Date InFirstLastEmailPhonePostcodeLead TypeLead SourceSales ConsultantItemPurchased?Marketing Opt OutDeadContact 1Contact 2
2
1​
16/3/17​
adamOrchardadamOrchard@gmail.com0400 111 222Sales LeadWebsiteAComputerNoNoYManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucher
3
2​
17/3/17​
alexAAalexAA@gmail.com0400 222 333Referal ProspectFacebookACablenoNoManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucher
4
3​
22/3/17​
michaekKerlinmichaekKerlin@gmail.com0400 333 444Sales LeadWebsiteAHTnoyManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucher
5
4​
20/3/17​
jamesRRjamesRR@gmail.com0400 444 555Referal ProspectFacebookBInstallnoNoYNO RESPONSE13/4/17 Emailed Finance email, with $100 fuel voucher
6
5​
22/3/17​
nicoleWrihtnicoleWriht@gmail.com0400 111 222Referal ProspectWebsiteBCablenoNoYManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucher
7
6​
27/3/17​
shellyFinnshellyFinn@gmail.com0400 222 333Referal ProspectFacebookBCableYesNoYManager LMTC 1/5/17
8
7​
24/3/17​
JeffBackenJeffBacken@gmail.com0400 333 444Sales LeadWebsiteCInstallnoNoYManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucher
9
8​
25/3/17​
AngelaMartinezAngelaMartinez@gmail.com0400 444 555Referal ProspectFacebookBInstallYesNoManager LMTC 1/5/17
10
9​
25/3/17​
NickTyrrellNickTyrrell@gmail.com0400 111 222Referal ProspectwebsiteCInstallYesNoYPURCHASED ELSEWHERE
11
10​
26/3/17​
Mohammed LakhmanMohammed Lakhman@gmail.com0400 222 333Referal ProspectwebsiteBCablenoNoPhone Disconnected13/4/17 Emailed Finance email, with $100 fuel voucher
12
11​
28/3/17​
JuhnayaRobertsJuhnayaRoberts@gmail.com0400 333 444
4570​
Referal ProspectwebsiteBInstallnoNoY WANTED TO NEGOTIATE13/4/17 Emailed Finance email, with $100 fuel voucher
13
12​
30/3/17​
ChloemcloughlinChloemcloughlin@gmail.com0400 444 555
4350​
Sales LeadwebsiteBCablenoNoManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucher
14
13​
30/3/17​
BenWilsonBenWilson@gmail.com0400 111 222
4171​
Referal ProspectwebsiteBComputeryesNoManager LMTC 1/5/17
15
14​
30/3/17​
BillieJeromeBillieJerome@gmail.com0400 222 333
4895​
Sales LeadwebsiteBComputeryesNoManager LMTC 1/5/17
16
15​
1/4/17​
MuhammadKhatreeMuhammadKhatree@gmail.com0400 333 444
4116​
Sales LeadfacebookCInstallnoNoPURCHASED ELSEWHERE13/4/17 Emailed Finance email, with $100 fuel voucher
17
16​
1/4/17​
GavinPrestonGavinPreston@gmail.com0400 444 555
4280​
Referal ProspectfacebookCInstallnoNoLOOKING FOR DIFFERENT ITEM13/4/17 Emailed Finance email, with $100 fuel voucher
18
17​
2/4/17​
Qing Qing @gmail.com0400 111 222
4122​
Sales LeadfacebookCInstallnoNoNO SHOW13/4/17 Emailed Finance email, with $100 fuel voucher
19
18​
2/4/17​
SootyPhomsouvanhSootyPhomsouvanh@gmail.com0400 222 333
4300​
Sales LeadfacebookAComputernoNoYWANTED TO NEGOTIATE13/4/17 Emailed Finance email, with $100 fuel voucher
20
19​
3/4/17​
GordonBrownGordonBrown@gmail.com0400 333 444
4017​
Sales LeadfacebookAComputernoNoNO RETURN CONTACT13/4/17 Emailed Finance email, with $100 fuel voucher
21
20​
3/4/17​
KerryGardnerKerryGardner@gmail.com0400 444 555
4880​
Referal ProspectwebsiteAInstallyesNoManager LMTC 1/5/17
22
21​
3/4/17​
MattHohnMattHohn@gmail.com0400 111 222
4006​
Sales LeadwebsiteDInstallnoNoYManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucher
23
22​
10/4/17​
Kylie Kylie @gmail.com0400 222 333
2484​
Sales LeadwebsiteDInstallnoNoManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucher
24
23​
10/4/17​
SuzanneMcneeseSuzanneMcneese@gmail.com0400 333 444
4077​
Referal ProspectfacebookDInstallnoNoPURCHASED ELSEWHERE13/4/17 Emailed Finance email, with $100 fuel voucher
25
24​
11/4/17​
ScottThomasScottThomas@gmail.com0400 444 555
4207​
Sales LeadfacebookBComputernoNoyManager LMTC 1/5/17
26
25​
1/3/17​
Theresa Theresa @gmail.com0444 987 789
4575​
Sales LeadfacebookBComputernonoyManager LMTC 1/5/17
27
26​
16/3/17​
StevenJaajaStevenJaaja@gmail.com0555 987 789
4209​
Referal ProspectfacebookCComputerElsewherenoManager LMTC 1/5/17
28
27​
18/3/17​
KelFlanKelFlan@gmail.com0411 111 111Sales LeadfacebookCComputerN/AnoyPURCHASED ELSEWHERE13/4/17 Emailed Finance email, with $100 fuel voucher
Sheet: Sheet1
 
Upvote 0
So on sheet 2 by example, i want to be able to enter the sales consultant D.
I want it to bring up all the details and 'leads' that they are working with crurrently

thanks :)
 
Upvote 0
Excel 2016 (Mac) 64 bit


B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
3
REP:A
4
5
Lead #Date InFirstLastEmailPhoneP/CLead TypeSourceInterested InPurchased?Marketing Opt OutDeadContact 1Contact 2Contact 3Contact 4Contact 5Contact 6Contact 7Contact 8Contact 9
6
2​
17/3/17​
alexAAalexAA@gmail.com0400 222 333Referal ProspectFacebookACablenoNoManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucherSend SMS 'still need a car" $250 fuel voucher
7
3​
22/3/17​
michaekKerlinmichaekKerlin@gmail.com0400 333 444Sales LeadWebsiteAHTnoyManager LMTC 1/5/1713/4/17 Emailed Finance email, with $100 fuel voucherSend SMS 'still need a car" $250 fuel voucher
8
19​
3/4/17​
GordonBrownGordonBrown@gmail.com0400 333 444
4017​
Sales LeadfacebookAComputernoNoNO RETURN CONTACT13/4/17 Emailed Finance email, with $100 fuel voucherSend SMS 'still need a car" $250 fuel voucher
9
20​
3/4/17​
KerryGardnerKerryGardner@gmail.com0400 444 555
4880​
Referal ProspectwebsiteAInstallyesNoManager LMTC 1/5/17
10
Sheet: Sheet2
 
Upvote 0
it is a central database of all our clients (as of today sitting at 1204 customers) we are adding an average of 500 per month.. so the logistics and sensitivity of the data is something we are trying to keep minimal hands on.. effectivly this will hopefully run as a separate sheet where try will be able to print their own appropriate records
 
Upvote 0
OK - understood. Please explain why lead #1 is not pulled through for sales rep A.
 
Upvote 0

Forum statistics

Threads
1,213,530
Messages
6,114,163
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top