Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and match names and extract a cell content
Hi
I have two spreadsheets both containing first and last name field (as well as other data elements). I would like to compare names on the two sheets and then once a match is found copy the contents of another column (password) to the second spreadsheet. Please let me know if any can assist with this ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and match names and extract a cell content
Are the first and last names in a single column?
If yes, then =vlookup() or =index(match()) would work nicely. You may want to read Debra Dalgleish's notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) ===== If they're in two different columns, you can use a formula like: =index(othersheet!$c$1:$c$100, match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0)) (one cell) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can't use the whole column. dexsourcesys wrote: Hi I have two spreadsheets both containing first and last name field (as well as other data elements). I would like to compare names on the two sheets and then once a match is found copy the contents of another column (password) to the second spreadsheet. Please let me know if any can assist with this ? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare 2 Sheets and Extract Unique Info to a 3rd Sheet | Excel Discussion (Misc queries) |