look up value from contents of list

asked 2019-10-18 11:53:50 +0100

GicleeChris gravatar image

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!

edit retag flag offensive close merge delete

Comments

Hi, are you able to upload a sample of you file?

gregors15 gravatar imagegregors15 ( 2019-10-18 12:54:46 +0100 )edit

=VLOOKUP(C2;$'Costing'.A2:I12;8;0)
H is the eighth column if the range starts with column A.
BTW: Better use the semicolon as the "function" separator. It doesn't get in conflict with internationally used decimal separators. You can set this separator under >Tools>Options>LibreOffice Calc>Formula>Separators.

Lupp gravatar imageLupp ( 2019-10-18 13:33:31 +0100 )edit