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 *************************************************************