Finding data in a Table

[goony]

Hello Folks,

I know this might be old question to many but I don't know anything about
Excel programming, and I need to get this done quick!

I have a big master Table of names and corresponding data in several columns. Now out of
those many names, I have a List of names that I would like to find their corresponding data.
I want to fill a list of names in a column and my program would fill in the corresponding data
in front of those names in several columns using the master Table.

I would be grateful if some folks would provide me with the code.

Goony

[dilipandey]

Hi Goony,

Welcome to the forum.

Try looking at vlookup function and in case of any issues, upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[goony]

Hello Dilip,

Thank you very much for your prompt response. Let me explain again what
I am trying to do.

I have a Table of 10,000 records numbered from 1 to 10000 on the leftmost
column, and each record contains data in 9 columns (field); Now I have a
list of 400 records numbered as 12, 45, 98, 135,...4639. Instead of doing a
Search and Find for each record number one by one, I want to find and list
those 400 records in one shot:

No.-------Item 1-------Item 2-------Item 3-------....--------Item 9
1 ------- abc ------- 1994 ------- .....
2
3
.
.
.
10,000----


Now I want to get:

No.-------Item 1-------Item 2-------Item 3-------....--------Item 9
12 ------ xyz ------- 1935 -------.....
45
98
135
.
.
.
4,639 ----

What is the best way to do this?

Goony

[dilipandey]

Hi Goony,

In your second table, you can apply below vlookup formula (since you have not given workbook but I will still try and provide you the formula logic which I am sure, you can apply in your workbook

=vlookup(<reference to No. and put $ sign before Column so if cell A2 has 12, enter $A2 here> ,<reference to your first table starting from leftmost column where you have No. till last column i.e, Item 9>,column(a$1),0)


Now drag this formula to right side and if everything OK, drag this to down till you have data in your second table


Regards,
DILIPandey

<click on below 'star' if this helps>

[AB33]

Goony,
What ever method you are going to use, it would be easier if you could attach a sample book with a desired result.

[goony]

Thank you folks,

Here is an example of a master Table containing 10 records of
movie information (the actual Table has 10,000 entries), and
I need to get information for three of them (the actual list is
made of 400 entries) in the next Table.

Thank you so much!

Goony

p.s. The title "Directorate" in the first Table should be "Director"......sorry....

[dilipandey]

Ok.. thx you finally uploaded the workbook

Try using below formula:-

Please Login or Register  to view this content.

Hope you can relate this to my earlier post

Sample.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[goony]

Thank you very much Dilip for your brilliant response. I read oodles and oodles of
stuff about VLOOKUP and still couldn't completely understand the darn thing!
And another thanks to AB33 for his remark .

Now that I have the information that I needed in one table, I need to convert that
Table from a formula filled table, to an independent table so I can remove the
master Table from the workbook. I need to have the actual data from the master
Table fill the inquiry table and get rid of the function form!

Any help would be highly appreciated...

Goony

[dilipandey]

Hi Goony,

If all the values have been brought - in by formulas and you wish to get rid of formulas, just copy all cells and paste special - values. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>