View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Match and Index vs natural language referencing

Debra Dalgleish has a lot of samples here



http://www.contextures.com/tiptech.html

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"DianeG" escreveu:

I have recently discovered cell referencing using labels ie you just type =
jan gin to find the intersecting values of the jan column and gin row. What
is the advantage of using the much more complicated Match and Index function?
Doesn't it do the same thing?

Thanks
Diane