Emergency vlookup code help!

[ElonD]

I've attached a copy of my spreadsheet. Basically I am new to excel, I need to find a formula which correctly retrieves all information from one sheet and populates it in the next.

The formula I currently use is:

=VLOOKUP(AQ10,PartsDownload!C14:L1452,5)

[TABLE="width: 106"]
<tbody>[TR]
[TD]To retrieve the information from the "Parts Download" sheet to the "Region Information" sheet.

[/TD]
[/TR]
</tbody>[/TABLE]


https://www.transferbigfiles.com/17c9c9af-4abb-47f1-8d71-db2e82a9d7ed/GGgk2SvVeWq0ExuSWRCxgA2

Any help is extremely appreciated!

 

[My Aswer Is This]

I do not believe you can do that with a formula.
I believe you will need a Vba Script.
I can write you a script. I will need:
1. Your Workbook will need to be Macro enabled.
2. Have you ever installed and or used a Macro script?

 

[ElonD]

This will be my first time working with Macros. I am good at taking instructions and applying them. The previous person working on this has made the workbook macro enabled I believe.

 

[My Aswer Is This]

So we want to make a copy of sheets "Parts Download"
And the new sheet should be named "Region Information"
Is this correct?

 

[ElonD]

I'd like to add that I really appreciate the help. You have no clue how much this helps me.

 

[ElonD]

Ok, to be completely specific. We need to have the items listed as (ACCESSORIES) under the (Part Type) setting on the "Parts Download" Sheet populate the (ACCESSORIES) section of the "Region Information" sheet which consists of columns: AQ & BI.

The idea is to copy the description from column (B) from "Parts Download" Sheet and have it populate the price from column (G) in "Parts Download" sheet, to Column (BI) in "Region Information" sheet.

 

[My Aswer Is This]

I'm sorry. I thought you just wanted the whole sheet copied.
I need to leave this question to someone else here at Mr. Excel.
I did not want to open your linked sheet in your original post and this may be beyond my knowledge base.

 

[ElonD]

no problem. Thanks for your time. It's well appreciated.

 

[ElonD]

Anyone else that may be able to give some instructions would be appreciated as well.