Pull info into Cells based on a lookup of a partial keyword

[Bond00]

So like the title suggests, i need to be able to pull info into cells below based on the first cells data. So for example.

I have a doc and in A1 i have Hewlett Packard, i would like to be able to search a different excel doc sheet that has a large list of names in the A column with 6 rows of data below the name and pull those into the next 6 cells below the cell i am searching based off of.

so like in my worksheet i have:
A1 = Hewlett Packard
A2 = pulled data
A3 = pulled data
A4 = pulled data
A5 = pulled data
A6 = pulled data
A7 = pulled data

based on what i have in Cell A1 in my doc it then searches through another excel doc based on a partial word title so for example it only searches for the match word "Hewlett" once it finds that in the other doc it pulls its next 6 values into the next 6 cells in my doc. the other doc is kind of being used as a lookup table database for the info.

Is this possible to do without vba? If not using vba will be ok.

thanks

 

[Bond00]

Re: Need to pull info into Cells based on a lookup of a partial keyword

If i need to rephrase it or elaborate on what i need let me know.

here is a visual of what i need.

[TABLE="width: 335"]
<tbody>[TR]
[TD]Company Name
[/TD]
[TD]company[/TD]
[/TR]
[TR]
[TD]Contact Name
[/TD]
[TD]name[/TD]
[/TR]
[TR]
[TD]Address
[/TD]
[TD]etc..[/TD]
[/TR]
[TR]
[TD]City State Zip
[/TD]
[TD]city, state zip[/TD]
[/TR]
[TR]
[TD]Country[/TD]
[TD]etc..[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Phone[/TD]
[TD]number
[/TD]
[/TR]
[TR]
[TD] Fax[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Email[/TD]
[TD]email
[/TD]
[/TR]
</tbody>[/TABLE]

when a company is typed into the Company Name field, i would like the other cells below it to auto-populate based on information it gets from another excel sheet with the info.
I haven't made that search file yet so it could either all be in Column A and have the other values below it or the name could be in column A and the other info be in B C D etc.. (it might be cleaner and more efficient to make that way)
So it just searches for a company match in the other sheet and pulls the data in to those cells based on that matched search. I would like it to be able to do a partial match if possible. e.g. If I type in General it will find General Motor but if there is other companies starting with General i can just type General Mo or the whole thing if needed etc.

is something like this possible with vlookup or would it just be easier to do with a macro?

 

[Bond00]

Re: Need to pull info into Cells based on a lookup of a partial keyword

*It didn't post with cell boarders before

[TABLE="class: grid, width: 335"]
<tbody>[TR]
[TD]Company Name
[/TD]
[TD]company[/TD]
[/TR]
[TR]
[TD]Contact Name[/TD]
[TD]name[/TD]
[/TR]
[TR]
[TD]Address
[/TD]
[TD]etc..[/TD]
[/TR]
[TR]
[TD]City State Zip
[/TD]
[TD]city, state zip[/TD]
[/TR]
[TR]
[TD]Country
[/TD]
[TD]etc..[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Phone[/TD]
[TD]number[/TD]
[/TR]
[TR]
[TD] Fax
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Email
[/TD]
[TD]email[/TD]
[/TR]
</tbody>[/TABLE]

this is the format of my sheet to pull the info into, the Bold starts in column B3 and the info is C3

 

[Bond00]

Re: Need to pull info into Cells based on a lookup of a partial keyword

Is this not something that's possible or is more detail needed?