Forum Discussion
Solved
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.
=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.
=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.
- Thank you, that worked!
