Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Tables
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Tables
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp / 2 Tables | Excel Discussion (Misc queries) | |||
can vlookup search multiple data tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
VLookUp Tables | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |