D Dave Peterson Oct 31, 2005 #2 Do you really mean put a value in a lookup table? Most questions around her ask about getting a value back from a lookup table. If I were using =vlookup(), the formula would look like: =vlookup(a1,sheet2!a:e,5,false) Debra Dalgleish's has some notes you may like: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match()))
Do you really mean put a value in a lookup table? Most questions around her ask about getting a value back from a lookup table. If I were using =vlookup(), the formula would look like: =vlookup(a1,sheet2!a:e,5,false) Debra Dalgleish's has some notes you may like: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match()))
