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.

Company Name	company
Contact Name	name
Address	etc..
City State Zip	city, state zip
Country	etc..
Phone	number
Fax
Email	email

<tbody>
</tbody>

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

Company Name	company
Contact Name	name
Address	etc..
City State Zip	city, state zip
Country	etc..
Phone	number
Fax
Email	email

<tbody>
</tbody>

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?