Library in Excel

  • Thread starter Thread starter Line Nissen
  • Start date Start date
L

Line Nissen

Hey

I would like to make a library in a Excel sheet, but i do not know how?

I would like it to do like this:

Material Lamdba value
Wood 0,12

So when i write "Wood" it gives me the lamdba value, 2 columns to the right


I hope someone can help me :)
 
Build a table on a dedicated sheet--in columns A:B.

Then you can use put your entry in A1 (of a different sheet) and use this in the
adjacent cell:

=vlookup(a1,sheet2!a:b,2,false)

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble

You may even want to make the cell where you put the material have a dropdown
showing you all the options.

Debra Dalgleish has some notes about naming the range:
http://contextures.com/xlDataVal01.html#Name
and using Data|validation on that same page.

Then the formula can change to:

=if(a1="","",vlookup(a1,sheet2!a:b,2,false)
 
Back
Top