Results 1 to 7 of 7

Search in a Matrix

Threaded View

  1. #1
    Registered User
    Join Date
    07-08-2010
    Location
    Lisbon
    MS-Off Ver
    Excel 2007
    Posts
    11

    Search in a Matrix

    Hello my friends.

    I hope you can help me here.

    I have an excel with a matrix like the following


    	      Abrantes	     Amiais 	       Benavente	Chamusca	      Constância
    Abrantes 		                58	             98	    40	                   14
    Alcanede 	66	                12	             67	    54         	   50
    Alcanena 	46	                10	             72	    32	                   36
    Almeirim 	66	                38	             34	    24	                   60
    In this matrix you have the "origin city" as rows on the left, the "destination city" as columns , and the values.

    What I need to do is, given a origin city and a destination city, the macro must read the value.

    Anyone can help me how to achieve this ?

    Thank you in advance,
    Bleeding_me
    Last edited by bleeding_me; 02-16-2012 at 06:51 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1