Hey all,
I'm trying to create a spreadsheet that references an existing Excel file that contains data in the following format:
Supervisor Name Email Phone #
Bob Joe (e-mail address removed) 555-555-1234
Bob Joy (e-mail address removed) 555-555-2345
Bob John (e-mail address removed) 555-555-3456
Colin Ricky (e-mail address removed) 555-555-4567
Colin Roy (e-mail address removed) 555-555-5678
Jerry Alex (e-mail address removed) 555-555-6789
Basically, what I want to do with this information is pull only, say, Colin's employees names and phone #'s, and not display anyone elses. So basically, I'd want it to look like this:
Colin's Employees
Name Phone Email
Ricky 555-555-4567 (e-mail address removed)
Roy 555-555-5678 (e-mail address removed)
I'm almost certain that the VLOOKUP command is what I want to use, but I'm unsure how to apply it to work in my case. I've tried a few different techniques such as...
=VLOOKUP("Colin",'[Existing Sheet.xls]Book1'!$A$2:$D$100,2,FALSE)
However this will display something like:
Colin's Employees
Name
Ricky
Ricky
Ricky
Ricky
Ricky
But will not show the other employees under Colin (In this case, Roy)..
If anyone has any idea, please save me from certain failure!
Thanks.
-Will
------=_NextPart_000_000C_01C6D81E.1375E5F0
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Google-AttachSize: 4759
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hey all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm trying to create a spreadsheet that references
an existing Excel file that contains data in the following format:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><STRONG>Supervisor
Name Email Phone #</STRONG></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT
face="Courier New">Bob Joe <A
href="mailto:
[email protected]">
[email protected]</A> 555-555-1234</FONT></FONT></DIV>
<DIV><FONT face="Courier New"
size=2>Bob Joy
<A href="mailto:
[email protected]">
[email protected]</A> 555-555-2345</FONT></DIV>
<DIV><FONT face="Courier New"
size=2>Bob John <A
href="mailto:
[email protected]">
[email protected]</A> 555-555-3456</FONT></DIV>
<DIV><FONT face="Courier New"
size=2>Colin Ricky
<A href="mailto:
[email protected]">
[email protected]</A> 555-555-4567</FONT></DIV>
<DIV><FONT face="Courier New"
size=2>Colin
Roy <A href="mailto:
[email protected]">
[email protected]</A>
555-555-5678</FONT></DIV>
<DIV><FONT face="Courier New"
size=2>Jerry Alex
<A href="mailto:
[email protected]">
[email protected]</A> 555-555-6789</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Basically, what I want to do with this information
is pull only, say, Colin's employees names and phone #'s, and not display anyone
elses. So basically, I'd want it to look like this:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><STRONG><U>Colin's
Employees</U></STRONG></FONT></DIV>
<DIV><FONT face="Courier New" size=2><STRONG>Name
Phone
Email</STRONG></FONT></DIV>
<DIV><FONT face="Courier New" size=2>Ricky
555-555-4567 <A
href="mailto:
[email protected]">
[email protected]</A></FONT></DIV>
<DIV><FONT face="Courier New" size=2>Roy
555-555-5678 <A
href="mailto:
[email protected]">
[email protected]</A></FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm almost certain that the VLOOKUP command is what
I want to use, but I'm unsure how to apply it to work in my case. I've tried a
few different techniques such as...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>=VLOOKUP("Colin",'[Existing
Sheet.xls]Book1'!$A$2:$D$100,2,FALSE)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>However this will display something
like:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><U><STRONG>Colin's
Employees</STRONG></U></FONT></DIV>
<DIV><FONT face="Courier New" size=2><STRONG>Name</STRONG></FONT></DIV>
<DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
<DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
<DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
<DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
<DIV><FONT face="Courier New" size=2>Ricky</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>But will not show the other employees under Colin
(In this case, Roy)..</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If anyone has any idea, please save me from certain
failure!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>-Will</FONT></DIV></BODY></HTML>
------=_NextPart_000_000C_01C6D81E.1375E5F0--
