I have a really simple requirement but nothing I’ve tried works.
I have a list of stock items on one sheet, with their unique descriptions and - via a few calculations - their sale prices.
Let’s say the sheet is called ‘Costing’, descriptions are in cells A2 - A12 and the calculated sale prices in cells H2 - H12. The value in H2 corresponds to the description in A2.
On another sheet called ‘Orders’ I’ve set up a drop-down list on this sheet in C2 (using the cell range A2 - A12), and depending on which value is selected I’d like the corresponding value from H2 - H12 to appear in cell D2.
The only function which gives me anything other than error codes is VLOOKUP - but the results are nonsense. Example: =VLOOKUP(C2,$‘Costing’.A2:I12,9,0)
This feels like it should be really simple, but I am stumped!