How to find the value of a cell in another tab based on cell criteria

user_15059084 0
Viewed 174

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.

google-apps-script google-sheets
1 Answers

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.

user_118321970
Related