I would like to reference column 1 from the value looked up in column 8. How???
C cecman Feb 13, 2005 #1 I would like to reference column 1 from the value looked up in column 8. How???
D Dave Peterson Feb 13, 2005 #3 And Debra Dalgleish has some nice instructions (for both =vlookup() and =index(match()) at: http://www.contextures.com/xlFunctions02.html and http://www.contextures.com/xlFunctions03.html
And Debra Dalgleish has some nice instructions (for both =vlookup() and =index(match()) at: http://www.contextures.com/xlFunctions02.html and http://www.contextures.com/xlFunctions03.html
