View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mnilo Mnilo is offline
external usenet poster
 
Posts: 17
Default Double Entry table

thanks both for your help, it is working perfectly now.


"Mnilo" escribió en el mensaje
...
Hi all:

I would like to know how to look for in a double entry table in Excel (a
table with row and colums of data).

For example in columns I have names of cities and in rows I have names of
companies, I would like (for example) a formula to introduce as imput
Boston and Microsoft and the formula will show the crossing of both
variables (for instance the number of employees of Microsoft in Boston).

Thank in advance.