Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data to matching records...
I've searched through the forums, and I'm having trouble applying any
solutions to my situation. I have two worksheets in my workbook, "MISC" and "durhambins". Here are the headers and one row of data from MISC. Part Description 400037 Instant Adhesive, Loctite 480 Here are the headers and one row of data from durhambins. Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE I need to have a column added to MISC that holds the correct BIN number for records with matching Part numbers (the first columns). So that in the end, the result of the above records would be: Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE Thank you in advance for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data to matching records...
I just realized how pointless this looks with the information I provided.
There are additional columns in each sheet, and the sheets were pulled from a database using different criteria. I promise that I'm not insane. "OcellNuri" wrote: I've searched through the forums, and I'm having trouble applying any solutions to my situation. I have two worksheets in my workbook, "MISC" and "durhambins". Here are the headers and one row of data from MISC. Part Description 400037 Instant Adhesive, Loctite 480 Here are the headers and one row of data from durhambins. Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE I need to have a column added to MISC that holds the correct BIN number for records with matching Part numbers (the first columns). So that in the end, the result of the above records would be: Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE Thank you in advance for any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data to matching records...
hi, on MISC, use =vlookup(a2,durhambins!a1:c1000,3,0)
adjust the range as your needs hth regards from Brazil Marcelo "OcellNuri" escreveu: I just realized how pointless this looks with the information I provided. There are additional columns in each sheet, and the sheets were pulled from a database using different criteria. I promise that I'm not insane. "OcellNuri" wrote: I've searched through the forums, and I'm having trouble applying any solutions to my situation. I have two worksheets in my workbook, "MISC" and "durhambins". Here are the headers and one row of data from MISC. Part Description 400037 Instant Adhesive, Loctite 480 Here are the headers and one row of data from durhambins. Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE I need to have a column added to MISC that holds the correct BIN number for records with matching Part numbers (the first columns). So that in the end, the result of the above records would be: Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE Thank you in advance for any help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data to matching records...
Thanks Marcelo.
I plug that in and it gives me a result of #N/A. "Marcelo" wrote: hi, on MISC, use =vlookup(a2,durhambins!a1:c1000,3,0) adjust the range as your needs hth regards from Brazil Marcelo "OcellNuri" escreveu: I just realized how pointless this looks with the information I provided. There are additional columns in each sheet, and the sheets were pulled from a database using different criteria. I promise that I'm not insane. "OcellNuri" wrote: I've searched through the forums, and I'm having trouble applying any solutions to my situation. I have two worksheets in my workbook, "MISC" and "durhambins". Here are the headers and one row of data from MISC. Part Description 400037 Instant Adhesive, Loctite 480 Here are the headers and one row of data from durhambins. Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE I need to have a column added to MISC that holds the correct BIN number for records with matching Part numbers (the first columns). So that in the end, the result of the above records would be: Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE Thank you in advance for any help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data to matching records...
all parts that you have in a both table are the same? and they are on the
same order (sort) regards "OcellNuri" escreveu: Thanks Marcelo. I plug that in and it gives me a result of #N/A. "Marcelo" wrote: hi, on MISC, use =vlookup(a2,durhambins!a1:c1000,3,0) adjust the range as your needs hth regards from Brazil Marcelo "OcellNuri" escreveu: I just realized how pointless this looks with the information I provided. There are additional columns in each sheet, and the sheets were pulled from a database using different criteria. I promise that I'm not insane. "OcellNuri" wrote: I've searched through the forums, and I'm having trouble applying any solutions to my situation. I have two worksheets in my workbook, "MISC" and "durhambins". Here are the headers and one row of data from MISC. Part Description 400037 Instant Adhesive, Loctite 480 Here are the headers and one row of data from durhambins. Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE I need to have a column added to MISC that holds the correct BIN number for records with matching Part numbers (the first columns). So that in the end, the result of the above records would be: Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE Thank you in advance for any help. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data to matching records...
The tables are not the same. I need to search for records that match part
numbers, and then append the BIN number from the durhambin sheet to the correct record in MISC. "Marcelo" wrote: all parts that you have in a both table are the same? and they are on the same order (sort) regards "OcellNuri" escreveu: Thanks Marcelo. I plug that in and it gives me a result of #N/A. "Marcelo" wrote: hi, on MISC, use =vlookup(a2,durhambins!a1:c1000,3,0) adjust the range as your needs hth regards from Brazil Marcelo "OcellNuri" escreveu: I just realized how pointless this looks with the information I provided. There are additional columns in each sheet, and the sheets were pulled from a database using different criteria. I promise that I'm not insane. "OcellNuri" wrote: I've searched through the forums, and I'm having trouble applying any solutions to my situation. I have two worksheets in my workbook, "MISC" and "durhambins". Here are the headers and one row of data from MISC. Part Description 400037 Instant Adhesive, Loctite 480 Here are the headers and one row of data from durhambins. Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE I need to have a column added to MISC that holds the correct BIN number for records with matching Part numbers (the first columns). So that in the end, the result of the above records would be: Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE Thank you in advance for any help. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data to matching records...
My mistake, it did work! I was getting #N/A because some of my records are
not repeated in both tables. Thank you for your help! "OcellNuri" wrote: The tables are not the same. I need to search for records that match part numbers, and then append the BIN number from the durhambin sheet to the correct record in MISC. "Marcelo" wrote: all parts that you have in a both table are the same? and they are on the same order (sort) regards "OcellNuri" escreveu: Thanks Marcelo. I plug that in and it gives me a result of #N/A. "Marcelo" wrote: hi, on MISC, use =vlookup(a2,durhambins!a1:c1000,3,0) adjust the range as your needs hth regards from Brazil Marcelo "OcellNuri" escreveu: I just realized how pointless this looks with the information I provided. There are additional columns in each sheet, and the sheets were pulled from a database using different criteria. I promise that I'm not insane. "OcellNuri" wrote: I've searched through the forums, and I'm having trouble applying any solutions to my situation. I have two worksheets in my workbook, "MISC" and "durhambins". Here are the headers and one row of data from MISC. Part Description 400037 Instant Adhesive, Loctite 480 Here are the headers and one row of data from durhambins. Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE I need to have a column added to MISC that holds the correct BIN number for records with matching Part numbers (the first columns). So that in the end, the result of the above records would be: Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE Thank you in advance for any help. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data to matching records...
regards and thanks for the feedback
Marcelo "OcellNuri" escreveu: My mistake, it did work! I was getting #N/A because some of my records are not repeated in both tables. Thank you for your help! "OcellNuri" wrote: The tables are not the same. I need to search for records that match part numbers, and then append the BIN number from the durhambin sheet to the correct record in MISC. "Marcelo" wrote: all parts that you have in a both table are the same? and they are on the same order (sort) regards "OcellNuri" escreveu: Thanks Marcelo. I plug that in and it gives me a result of #N/A. "Marcelo" wrote: hi, on MISC, use =vlookup(a2,durhambins!a1:c1000,3,0) adjust the range as your needs hth regards from Brazil Marcelo "OcellNuri" escreveu: I just realized how pointless this looks with the information I provided. There are additional columns in each sheet, and the sheets were pulled from a database using different criteria. I promise that I'm not insane. "OcellNuri" wrote: I've searched through the forums, and I'm having trouble applying any solutions to my situation. I have two worksheets in my workbook, "MISC" and "durhambins". Here are the headers and one row of data from MISC. Part Description 400037 Instant Adhesive, Loctite 480 Here are the headers and one row of data from durhambins. Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE I need to have a column added to MISC that holds the correct BIN number for records with matching Part numbers (the first columns). So that in the end, the result of the above records would be: Part Description Bin 400037 Instant Adhesive, Loctite 480 FRIDGE Thank you in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Copy all records matching "Text" criteria to new worksheet | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Find matching records in two worksheets | Excel Discussion (Misc queries) |