G Gord Dibben Feb 17, 2005 #2 Mike That would indicate the data you are looking for cannot be found. Post the formula and a sample of your data(not a file, just a sample). Gord Dibben Excel MVP
Mike That would indicate the data you are looking for cannot be found. Post the formula and a sample of your data(not a file, just a sample). Gord Dibben Excel MVP
M Mike Feb 18, 2005 #3 Hi Gord, I got it to work, instead of making a new sheet for the lookup data, I placed it on the sheet itself. Thank you.
Hi Gord, I got it to work, instead of making a new sheet for the lookup data, I placed it on the sheet itself. Thank you.
G Gord Dibben Feb 18, 2005 #4 Mike Thanks for the feedback Mike. You can however, have a separate sheet for the lookup data. Select your lookup table on other sheet and give it a name through Insert>Name?Define. Call it mytable and be sure it refers to =othersheet!range =VLOOKUP(cell,mytable,col_no,0) or FALSE instead of 0 Gord
Mike Thanks for the feedback Mike. You can however, have a separate sheet for the lookup data. Select your lookup table on other sheet and give it a name through Insert>Name?Define. Call it mytable and be sure it refers to =othersheet!range =VLOOKUP(cell,mytable,col_no,0) or FALSE instead of 0 Gord
