Ask Your Question

Adding values from a named list

asked 2017-08-29 15:00:35 +0100

Helge gravatar image

I have a sheet of resistors, names in one column and value in an other column, it is possible to lookit up with VLOOKUP or HLOOKUP but I should like to get the values automatic added from a list of resistor names.

Sheet 1: list of resistor names and its value; Sheet2 a column given a list of resistor names and a field there the resistors is added up. Say "R1+R2+R342+A34" and its value it's added up, other formula should work also if operator is possible, operator @ as VLOOKUP and given tables of names and value. "@R1+@R2+@R342+@A34" More complex ""@R1//@R2" there R1 and R2 resistors are in parallel recording formula R=1/(1/R1+1/R2) there // is an other operator. Now I don't know if that is working in any languages or exchange @ and // with SER(R1,R2) och PA(R1,R2) there SER o PAR is working more as a function.

Its little hard to explain.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-08-30 00:34:01 +0100

m.a.riosv gravatar image

You can assign names to the values selecting the columns used for VLOOKUP and creating the range names with Menu/Sheet/Named range or Expressions/Create - Left. Then it's possible use those names in the cells for calculations.

LibreOffice Calc Guide chapter 13 - Associating a name with a range.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-29 15:00:35 +0100

Seen: 76 times

Last updated: Aug 30 '17