close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()