LOOKUP to return values from multiple columns

I've been a casual Excel user for years and by no means an expert so I could use some help. What I'm trying to do is create a spreadsheet that will look to MFR pricing spreadsheets on our server and return values in subsequent cells-like this;

A B C D E F
1 EA Joe's Parts Joe's parts model A Joe's parts model A description Joe's parts model A price

Columns A&B would be manual entry with no formulas/links.
Column C would be manual entry but point to a spreadsheet on our server based on MFR name text entered.
Column D, E & F would autofill from same spreadsheet once the model # is filled in.
And column F would increment with qty in column A. (I got this!)

Thank you!

I understand but I need to return more than just a column/cell value. I want to look up another spreadsheet based on my text entered in a cell.
Then in the next cell reference said spreadsheet and drill down to a particular part number that I am now typing and autofill the next 2 columns.
(All in the same row). I read thru the link you posted but I don't think it addresses my exact need.

Thanks for your help!

Since I don't have anything done yet, I've attached a pdf of a sample spreadsheet that hopefully explains what I'm trying to accomplish.

So with the example you posted above, we're pointing cell F2 to the 2nd row, 3rd column on the first sheet. And the same for cell G2 but the 4th column. I get it.

What I'm trying to do is "when I enter part# 220 in my second sheet, I want it to autofill columns F and G from columns C and E from the first sheet (in this case).
Sounds confusing?

Thanks. Let me digest this and I'll get back tomorrow.
I don't know what you mean by a sample workbook. I'm trying to create this from the ground up and the only thing I can offer is a generic manufacturer's price sheet (which is represented by the "first sheet" above).

Then you need
F2 =VLOOKUP(E2,'First Sheet'!$A$2:$E$2,3,0)
G2 =VLOOKUP(E2,'First Sheet'!$A$2:$E$2,5,0) <- changed the 4 to 5

OK, thank you for your help. I got it to work...when I have the database in the same work book. Now I have to make it grab the data from another workbook on our network. The problem now is I'm getting a #VALUE error.

Here is my function;

=VLOOKUP(E4='\\Our Company\Share\SALES & MARKETING\Manufacturer Pricing\ACME Products\[price_list-03.28.17.xls]Control Systems'!$A$1:$E$147,2,0)

The part number I enter is in column B of this source spreadsheet, but even if I use the associated data from column A I get the same #VALUE! return.

That = after E4 needs to be a comma.

I've changed the = to a comma and now it's pulling up the folder where price_list-03.28.17.xls is located and asking for Update Values. This happens continuously.