Re: Help using two different values in a lookup table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Peo Sjoblom (terre08_at_mvps.org)
Date: 05/26/04 

Date: Tue, 25 May 2004 22:45:16 -0400

=INDEX(A1:S50,MATCH(Origin_cell,A1:A50,0),MATCH(Destination_cell,A1:S1,0))

will return the cell in the table where the intersection is, so if it looks
up H1 and A30 then the
returned value will be from H30 

-- 
For everyone's benefit keep the discussion in the newsgroup.
Regards,
Peo Sjoblom
"shadestreet >" <<shadestreet.16udha@excelforum-nospam.com> wrote in message
news:shadestreet.16udha@excelforum-nospam.com...
> Help using the Lookup Function
> I need to search for a value based on two different criteria.
>
> I have only used VLookup or HLookup for 1 criteria, and would like to
> know how to use a combination of the two. I am sure there are multiple
> approaches, but I wanted to know the simplest method.
>
> Basically, I have created a spreadsheet to calculate distances which
> are dependant on "origin" and "destination".  There are 8 possible
> locations, any of them can be the origin or the destination.  I made a
> distance matrix on a different sheet that has the travel distance for
> each of the 64 combinations.
>
> On my my first sheet (titled "Distance") I use two adjacent cells, one
> titled "origin", and the other "Destination".  The user will select the
> origin and destination from the Validation list, and I want the third
> adjacent cell to lookup and return the distance from the matrix on the
> second page (titled "DMatrix").
>
> Last month I posted basically the same question and Frank was kind to
> answer, but I couldn't get it work (used a combination of Index and
> matching).  Can someone explain how to achieve this?
>
> Thanks
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: OT: Long Distance, phone card
    ... but they billed Gawd-Knows-What even before I used it, ... to switch long distance carriers. ... when the cell system is on its knees or down completely. ... of our house lighted. ...
    (alt.home.repair)
  • Re: Looking for info
    ... It goes to the local cell tower and gives you a dial tone then you dial ... of the long distance cell phone without long distance ... distance service charges. ...
    (alt.security.alarms)
  • Re: Disassembling Rubinar 10/1000
    ... flattener lens, otherwise I'm not sure I could focus to infinity. ... That's not enough distance to mount any 1.25" diagonal. ... the front cell itself can be unscrew all the way ...
    (sci.astro.amateur)
  • Re: cell phone booster
    ... plans for people like me with extremely low cell use. ... Multiple lines, multiple long distance, multiple voice mail, multiple ... part cut out of the mix because I have a 3rd party no-fee plan for that. ...
    (sci.electronics.design)
  • Re: cell phone booster
    ... Then about a month ago cell service out here dropped dead. ... the cost skyrocket unless you have an expensive super-fat cell plan. ... Multiple lines, multiple long distance, multiple voice mail, multiple ...
    (sci.electronics.design)