Sheet 1 shows quantity in column, Sheet 2 shows quantity and its value in next column

New Contributor

Hi All,

Sheet1 shows a quantity  as a number in column D

Sheet2 shows a quantity (1-200) in column A and its price in column B

I would like to be able to automatically show the value based on quantity in (Sheet1) Column D in (Sheet1) Column N from the values held in Sheet2

I'm new to this...


2 Replies
best response confirmed by Pivkobeer (New Contributor)



You can try VLOOKUP or INDEX / MATCH as shown in the attached file. If you work with Office365 you can apply XLOOKUP.