| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming A Table Array in Vlookup
Hi,
I want to name a Table array for VLookUp ie, I have an excel sheet with =IF(C10="","",VLOOKUP(C57,job,2,FALSE)) job = I18:O29 So my question is how do I make a work represent a table array? I want to know this to have more control over my formulas as i cut and paste Thanks hhhh |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Naming A Table Array in Vlookup
Hi
use 'Insert - Name - Define' for this -- Regards Frank Kabel Frankfurt, Germany "hhhh" schrieb im Newsbeitrag om... Hi, I want to name a Table array for VLookUp ie, I have an excel sheet with =IF(C10="","",VLOOKUP(C57,job,2,FALSE)) job = I18:O29 So my question is how do I make a work represent a table array? I want to know this to have more control over my formulas as i cut and paste Thanks hhhh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP & non-contiguous table array | Excel Worksheet Functions | |||
| VLOOKUP -- Table Array Problem | Excel Worksheet Functions | |||
| array table and vlookup | Excel Worksheet Functions | |||
| i want to do a vlookup but i want the table array to be changing | Excel Worksheet Functions | |||
| VLOOKUP - 3 Table Array | Excel Worksheet Functions | |||
Linear Mode
