Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fletcher
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
populating sheets based on data from parent sheets seve Excel Discussion (Misc queries) 2 January 15th 05 10:22 PM
pull data from sheet two, then fill in the data to sheet one (part Jim Excel Worksheet Functions 3 December 11th 04 05:51 AM
data entry on multiple worksheets diosdias Excel Discussion (Misc queries) 1 December 7th 04 06:33 PM
Formula to Extract Data from a Table Macshots Excel Worksheet Functions 2 November 5th 04 07:35 AM
How to populate column with formula based on value in cell Cameron Stewart Excel Worksheet Functions 2 November 2nd 04 02:36 AM


All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"