SOLVED

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

Copper Contributor

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

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 (Copper Contributor)
Solution

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

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

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

Thank you, that worked!
1 best response

Accepted Solutions
best response confirmed by Pivkobeer (Copper Contributor)
Solution

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

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