Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Grab matching data and populate?
Sorry for the silly subject line there, wasn't sure how to phrase what I
need. I have an XLS with multiple worksheets. Here's what I need to do: In sheet1, I have column D populated with asset serial numbers (alphanumeric values, like HFK6X01 for example), then in sheet2, I have 10,000+ rows of data. In sheet2, there is also a column (column A) full of serial numbers like the one mentioned, but there are also columns that have additional information about the asset, like when we bought it, how much it cost, etc... I want to search sheet2 for matches of the values in sheet1 column D, and when a match is found in sheet2, I want to grab the correlating data for that matched value ( like when we bought it, how much it cost, as mentioned above). I'm not sure if that makes sense, so let me draw it out in simple fashion: sheet1 - column D sheet2 column A HRE785 HFK6X01 3,402.47 11/23/02 HFK6X01 ZGKY784 F454TG9 8MKO930 (on and on) So, the formula in sheet1 would find the match in sheet2 in cell A1, and so therefore grab the values in B1 and C1 and put them next to the match in sheet1. I hope this makes sense. Thanks in advance, this NG is great. Craig |
#2
|
|||
|
|||
Hi
use VLOOKUP. See: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany Fletcher wrote: Sorry for the silly subject line there, wasn't sure how to phrase what I need. I have an XLS with multiple worksheets. Here's what I need to do: In sheet1, I have column D populated with asset serial numbers (alphanumeric values, like HFK6X01 for example), then in sheet2, I have 10,000+ rows of data. In sheet2, there is also a column (column A) full of serial numbers like the one mentioned, but there are also columns that have additional information about the asset, like when we bought it, how much it cost, etc... I want to search sheet2 for matches of the values in sheet1 column D, and when a match is found in sheet2, I want to grab the correlating data for that matched value ( like when we bought it, how much it cost, as mentioned above). I'm not sure if that makes sense, so let me draw it out in simple fashion: sheet1 - column D sheet2 column A HRE785 HFK6X01 3,402.47 11/23/02 HFK6X01 ZGKY784 F454TG9 8MKO930 (on and on) So, the formula in sheet1 would find the match in sheet2 in cell A1, and so therefore grab the values in B1 and C1 and put them next to the match in sheet1. I hope this makes sense. Thanks in advance, this NG is great. Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
Formula to Extract Data from a Table | Excel Worksheet Functions | |||
How to populate column with formula based on value in cell | Excel Worksheet Functions |