View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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