ExcelBanter - Vlookup Tables

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup Tables (https://www.excelbanter.com/excel-worksheet-functions/71749-vlookup-tables.html)

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

"Lianne" wrote:

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