I have a Wholesale market price in a list on a sheet called 'DataBank' Name of the product is column W & Price in column X

In a seperate tab called 'Position Activity' I have a drop down list in column AL based on the values of column W of the 'DataBank' sheet

When selecting the product in the dropdown list I would like the corresponding price to populate the cell next to the drop down list in column AK

Is there any help on offer for this? ideally in a script.

Thanks in advance.

CodePudding user response：

This is the formula I'd put in cell next to the dropdown list: =INDEX('DataBank'!X2:X;MATCH(AK2;'DataBank'!W2:W;0))

INDEX and MATCH offer more flexibility than VLOOKUP when it comes to data format and the order/or how random the columns are. Not tested.