View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default vlookup question

Select the range of cells and do
Insert =Name=Define

The "refers to" box should be defaulted to the selected cells

in the name box put in HeightArray and click ADD.

alternately, with the area selected, go to the name box and enter
HeightArray <Enter key

--
Regards,
Tom Ogilvy

"JR Winder" wrote in message
...
When you say "label your height values "HeightArray"; your
width values "WidthArray" and your actual prices "PriceArray" how
exactly do I do that?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!