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