[mso] Re: Excel
- From: "Ray Blake" <ray@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 11 Jun 2004 22:37:21 +0100
OK, taking this one point at a time...
>>too cool for school Ray, thanks.<<
Sorry, I've no idea what that means. I'm English. Sorry.
>>I don't understand completely how to use but...
with the VLOOKUP, I need to know one piece of the value, Barbara, in
your example. can this be a range? what happens if there is more than
one Barbara?<<
OK. There are a couple of parts to the VLOOKUP. The first argument is
what value you want to search for. Assuming your names are in A1:A100
and you have the formula in column F, F1 should be looking for the value
in A1, F2 should be looking for the value in F2, etc. Each of the cells,
though, from F1 to F100 will be looking in the same range, and that
range will be the one which exists in the second worksheet from which
you'd like to lift the information.
>>I tried it have a row 7 with Barbara, 19, Lassister. The range is
absolute A$2:C$7. I got Babara, 23, but never got Barbara 19. I tried
a range instead of Barbara and got the age of each person in the list
which is ok but I already that in the age column.<<
Now I'm lost. If you have dupe values, VLOOKUP will only find the first
match. What you can do, though, is make a new column and concatenate
whatever columns are common to both sheets, so you end up looking for
something like Barbara19Lassiter, which hopefully won't be duplicated.
>>I haven't done anything with HLOOKUP yet, got confused already.<<
If your data goes across rows, with column headings, you don't need to
use HLOOKUP. If you need more help than this, try to give us a few lines
of example data from the two sheets.
Ray
-----Original Message-----
From: Ray Blake [mailto:ray@xxxxxxxxx]
Yes, there is. You'll need to use a VLOOKUP formula to do it. I have a
tutorial article on LOOKUP formulae here:
http://www.grbps.com/articles.htm
Look for the Excel article called 'Excel Lookups Explained'. After
making this work, if you want to make the union permanent, you could
copy the new columns built from LOOKUP formulae and then use a
Paste-Special-Values if you wanted to make them permanent.
If you get into trouble, post a description of the structure of the two
sheets and I'm sure I or someone else will be able to create the full
formula.
Ray
------------------------------------
GR Business Process Solutions
Ray Blake
Head of Software Design
ray@xxxxxxxxx
Braedon
Newell Road
Hemel Hempstead
Herts HP3 9PD
tel: 01442 396518
fax: 01442 389353
www.grbps.com
------------------------------------
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
