Index Match with variable headings

[kaoticone]

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.

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

Thanks
Damian


.