I know how to use the Vlookup Functions but i have totally forgot how to
define the table for it to look in! its really stressing me out i cant use
Sheet1 etc because there is more than one table on the sheet
Lianne, you can have more than one table in a sheet. This is not a problem.
The table is not specifically defined in the sense that it does not have to
be given a name, but there can be advantages to naming the table. The first
column though must be in numerical order; the first column being the value
you are looking up for.
--
Creatorquot;Liannequot; wrote:
gt; I know how to use the Vlookup Functions but i have totally forgot how to
gt; define the table for it to look in! its really stressing me out i cant use
gt; Sheet1 etc because there is more than one table on the sheet
- Jun 22 Fri 2007 20:38
Vlookup Tables
close
全站熱搜
留言列表
發表留言