B bingy Feb 11, 2004 #1 Lookup seems do an inexact lookup,How should I do an exact one? Thanks for your answer. (e-mail address removed)
Lookup seems do an inexact lookup,How should I do an exact one? Thanks for your answer. (e-mail address removed)
J John Wilson Feb 11, 2004 #2 bingy, Use the "False" argument at the end. =VLOOKUP(what,where,index,False) John
B bingy Feb 11, 2004 #3 VLookup & HLookup seems to demand the key to be in the 1st row or column, and I could not get by it. How? bingy
VLookup & HLookup seems to demand the key to be in the 1st row or column, and I could not get by it. How? bingy
G Gord Dibben Feb 11, 2004 #4 bingy See Chip Pearson's site for "left lookups". http://www.cpearson.com/excel/lookups.htm#LeftLookup Gord Dibben Excel MVP
bingy See Chip Pearson's site for "left lookups". http://www.cpearson.com/excel/lookups.htm#LeftLookup Gord Dibben Excel MVP
