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

Naming A Table Array in Vlookup
 

in the menu do
Insert=Name=Define

name: Job
RefersTo: =Sheet1!$I$18:$O$29

Then click the add button.

Change the Sheet1 to the name of the sheet where the table is located.

--
Regards,
Tom Ogilvy

"hhhh" wrote in message
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