SOLVED

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...

Thanks,
Simon.

2 Replies
best response confirmed by Pivkobeer (New Contributor)
Solution

@Pivkobeer 

=VLOOKUP(D2,Sheet2!$A$2:$B$200,2,FALSE)

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