Index Match with variable headings

kaoticone

New Member
Joined
Jul 12, 2013
Messages
1
Hi Guys and Girls,

I'm in a bit of a pickle and need some help.

I've been tasked to try and automate some sheets using the (index\match function) now this can be either in VBA or just per cell.
Currently I was doing just per cell.

Currently I have a list of headings for items that can change from a supplier along Row 2 on the vendor sheet. the reason for this is different suppliers can have different layouts and I need to unify it into a single template.

On the vendor tab I have a drop down list based on the headings on the jimimport sheet that need to match with each other and pull the info for the vendor sheet based on the heading and place it into the correct Colum on the jimimport sheet.

Hope that make sense

Here is what I have done so far. It is returning from the stock code section but no mater what I change the heading too, the results don't change

for example
vendor tab
Colum G select Stock Code heading
look from G5 to AA50 and match with values that correspond with Colum with heading of stock code. Which is Colum G for this one

I'm not sure why in the Jimimport sheet it is giving me all these values when I only have one cell with code in it.

any help is much apricated.

Excel Formula:
=INDEX(Vendor!$G$2:$BC$50,MATCH(Vendor!$G5:$G$50,Vendor!$G$2:Vendor!$G$5:$G$50,0),1)

Thanks
Damian


.
vendor with list.jpg






jimimport with index.jpg
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,123,359
Messages
5,601,153
Members
414,431
Latest member
JustmemyselfandI

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top