G Guest Nov 8, 2003 #1 VLOOKUP returns a result to the right a given number of columns from the search column. Is there a way to do a lookup that returns the result by looking to the left of the search column?
VLOOKUP returns a result to the right a given number of columns from the search column. Is there a way to do a lookup that returns the result by looking to the left of the search column?
C Chip Pearson Nov 9, 2003 #2 John, See the Left Lookups section at www.cpearson.com/excel/lookups.htm . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed) John said: VLOOKUP returns a result to the right a given number of columns from the Click to expand... search column. Is there a way to do a lookup that returns the result by looking to the left of the search column?
John, See the Left Lookups section at www.cpearson.com/excel/lookups.htm . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed) John said: VLOOKUP returns a result to the right a given number of columns from the Click to expand... search column. Is there a way to do a lookup that returns the result by looking to the left of the search column?