Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I cross reference 1 excel spreadsheet against another
Please help!
I have a very simple database of names & addresses on 1 excel spreadsheet and I want to cross reference them against another. I sthere a quick way of doing this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I cross reference 1 excel spreadsheet against another
Maybe using =vlookup() or =index(match()).
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())) SusieMuir wrote: Please help! I have a very simple database of names & addresses on 1 excel spreadsheet and I want to cross reference them against another. I sthere a quick way of doing this? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I cross reference 1 excel spreadsheet against another
Using an unique identifier between the two, look in Excel help at
Vlookup or if the identifier is no in the left most column of the data of interest then look at =Index(Othersheet!column1,match(identifier,OtherSh eet!column3,0),1) where the pseudo references would need to be replaced by the actual range references. -- Regards, Tom Ogilvy "SusieMuir" wrote: Please help! I have a very simple database of names & addresses on 1 excel spreadsheet and I want to cross reference them against another. I sthere a quick way of doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing an Excel spreadsheet from the web. | Excel Discussion (Misc queries) | |||
Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
windows explorer will not open an excel spreadsheet. | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |