Hi
I would like a formula to match results based on a cell value (Sheet2, cell D1).
The attached excel shows data in Sheet1 and the expected results in Sheet2.
As an example if D1 has a value of C, then the corresponding values should read 20, 16, 9, 6 and 50 from C2 to C6.
Thanks.
Bookmarks