| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with spreadsheet
Hello,
I have 2 spreadsheets and I would like to compare the 2, on one I have a serial # and a name and on the other I have a serial # and a date. I would like to combine the 2 spreadsheets into one by matching up the 2 serial #'s... does anyone know of a way to do this? Thanks Gavin... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with spreadsheet
A simple VLOOKUP should do it. Look in the help index
-- Don Guillett Microsoft MVP Excel SalesAid Software "gavin" wrote in message ... Hello, I have 2 spreadsheets and I would like to compare the 2, on one I have a serial # and a name and on the other I have a serial # and a date. I would like to combine the 2 spreadsheets into one by matching up the 2 serial #'s... does anyone know of a way to do this? Thanks Gavin... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with spreadsheet
trying to use vlookup and not getting any results... this is what I am
doing... sheet1 - has Serial# and Model # sheet2 - has Serial# and Computer Name this is what I have in the formula =VLOOKUP(E15,Sheet2!A1:B557,2,FALSE) E15= cell that has the serial # in sheet1 Sheet2!A1:B557 = all values on sheet 2 2 = column # (this is the serial# column) False = exact match not sure where I am going wronng... Thanks Gavin.... "Don Guillett" wrote in message ... A simple VLOOKUP should do it. Look in the help index -- Don Guillett Microsoft MVP Excel SalesAid Software "gavin" wrote in message ... Hello, I have 2 spreadsheets and I would like to compare the 2, on one I have a serial # and a name and on the other I have a serial # and a date. I would like to combine the 2 spreadsheets into one by matching up the 2 serial #'s... does anyone know of a way to do this? Thanks Gavin... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with spreadsheet
Example only................
sheet1 has serial numbers in column E and model numbers in column F sheet2 has same serial numbers in column A and Computer Name in column B In G1 of sheet1 enter =VLOOKUP(E1,sheet2!$A$1:$B$557,2,false) Copy that down column G BTW...........what happened to the "date" on sheet2? Gord Dibben MS Excel MVP On Thu, 28 Aug 2008 16:22:00 -0700, "gavin" wrote: trying to use vlookup and not getting any results... this is what I am doing... sheet1 - has Serial# and Model # sheet2 - has Serial# and Computer Name this is what I have in the formula =VLOOKUP(E15,Sheet2!A1:B557,2,FALSE) E15= cell that has the serial # in sheet1 Sheet2!A1:B557 = all values on sheet 2 2 = column # (this is the serial# column) False = exact match not sure where I am going wronng... Thanks Gavin.... "Don Guillett" wrote in message ... A simple VLOOKUP should do it. Look in the help index -- Don Guillett Microsoft MVP Excel SalesAid Software "gavin" wrote in message ... Hello, I have 2 spreadsheets and I would like to compare the 2, on one I have a serial # and a name and on the other I have a serial # and a date. I would like to combine the 2 spreadsheets into one by matching up the 2 serial #'s... does anyone know of a way to do this? Thanks Gavin... |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with spreadsheet
here's the catch, the serial numbers are not the same, the sheet2 may or may
not have the serial# in sheet1, what I want to do is match up the ones that are in sheet2 with sheet1 and if there is no match just put a "no match" in the cell... is this possible... for example Column A Column B Computer Name Serial # computer1 1234 (sheet2) computer2 1235 computer4 1237 Model # Serial # Dell 620 1234 (Sheet1) Dell 620 1235 Dell 620 1236 Dell 620 1237 Model # Serial # Computer Name Dell 620 1234 computer1 (sheet1 Column C) this us what I am trying to achive... Dell 620 1235 computer2 Dell 620 1236 No Match Dell 620 1237 computer 4 Thanks Gavin... "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Example only................ sheet1 has serial numbers in column E and model numbers in column F sheet2 has same serial numbers in column A and Computer Name in column B In G1 of sheet1 enter =VLOOKUP(E1,sheet2!$A$1:$B$557,2,false) Copy that down column G BTW...........what happened to the "date" on sheet2? Gord Dibben MS Excel MVP On Thu, 28 Aug 2008 16:22:00 -0700, "gavin" wrote: trying to use vlookup and not getting any results... this is what I am doing... sheet1 - has Serial# and Model # sheet2 - has Serial# and Computer Name this is what I have in the formula =VLOOKUP(E15,Sheet2!A1:B557,2,FALSE) E15= cell that has the serial # in sheet1 Sheet2!A1:B557 = all values on sheet 2 2 = column # (this is the serial# column) False = exact match not sure where I am going wronng... Thanks Gavin.... "Don Guillett" wrote in message ... A simple VLOOKUP should do it. Look in the help index -- Don Guillett Microsoft MVP Excel SalesAid Software "gavin" wrote in message ... Hello, I have 2 spreadsheets and I would like to compare the 2, on one I have a serial # and a name and on the other I have a serial # and a date. I would like to combine the 2 spreadsheets into one by matching up the 2 serial #'s... does anyone know of a way to do this? Thanks Gavin... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data from a changing spreadsheet to a constant spreadsheet | Excel Programming | |||
| link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming | |||
Hybrid Mode
