Lookup in Excel 1

[RFeniuk]

I have a table of information that I want to run a lookup on. The table is set up like this:
Col. A - Company Name
Row 1 - Destination

What I want to do is have Excel return the value in a cell where the comapny name and destination meet. Can I do this and how do I do this?

Thanks.

 

[KenWright]

With your dests in B1:M1, and your companies in A3:A27, and with the company name being looked up being in A29, and dest being looked up in B29, in any other cell use:-

=OFFSET($A$1,MATCH($A$29,$A$2:$A$27,0),MATCH($B$29,$B$1:$M$1,0))

Regards
Ken....................

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

 

[KenWright]

The other option of course, is that assuming A1 was blank (You can change it later, but it needs to be blank to start), is to select A1:M27, then do Insert / Name / Create and select both Top Row and Left Column from the choices given and then hit OK.

You can now simply type company dest in a cell, ie type the company name and the destination with a space in between, and it will look up the intersection.

You do need to have 'Accept Labels in formulas' checked in options, and you are better off having no spaces in the names. Personally though, I prefer the formula.

Regards
Ken................

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------