Vlookup Tables

L

Lianne

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
 
C

Creator

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.
 
Top