| 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... |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with spreadsheet
Use the match index as suggested by Don. Here is the sample formula
for cell C2- =index(Sheet1!$A$1:$A$10,match(b2,Sheet1!$B$1:$b$1 0,1),1) On Aug 29, 5:19*pm, "Don Guillett" wrote: vlookup has to lookup columns to the right. So, use MATCH to find the serial number in col B and then use that within an INDEX formula on col A to get the computer name. Look in the help index for both. -- Don Guillett Microsoft MVP Excel SalesAid Software "gavin" wrote in message ... 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...- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with spreadsheet
I did what you said and my colomn returns nothing...I have attached the
spreadsheet, maybe you can see where I am going wrong. Thanks Gavin... "Avi" wrote in message ... Use the match index as suggested by Don. Here is the sample formula for cell C2- =index(Sheet1!$A$1:$A$10,match(b2,Sheet1!$B$1:$b$1 0,1),1) On Aug 29, 5:19 pm, "Don Guillett" wrote: vlookup has to lookup columns to the right. So, use MATCH to find the serial number in col B and then use that within an INDEX formula on col A to get the computer name. Look in the help index for both. -- Don Guillett Microsoft MVP Excel SalesAid Software "gavin" wrote in message ... 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...- Hide quoted text - - Show quoted text - |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with spreadsheet
|
| 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 | |||
Linear Mode
