Two entry table

[AM]

Hello

How can I simple search a value in a two entry table,

Ex:

Antony Andrew Dorothy
Age 31 56 67

Weight 80 67 56

Height 1,80 1,70 1,59


Giving Antony and Weight, I would like that excel returns me 80. That's possible without using VBA?

Thanks


AM

 

[Legacy 98055]

See the HLookup function...

 

[Scott Huish]

I think the op may be looking for the name and the literal text Weight from Column A.

In this example, I have the name to lookup in A8, and the text to lookup in A9.

=INDEX($B$2:$D$4,MATCH(A9,$A$2:$A$4,0),MATCH(A8,$B$1:$D$1,0))<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]

 

[Legacy 98055]

Hi Hotpepper. What are you doing to that cat?
I should not even try and answer non VBA questions.

=HLOOKUP(A7,A1:D4,MATCH(A8,A1:A4,0),FALSE)

<a href="http://home.fuse.net/tstom/0610081940.zip"><img src="http://home.fuse.net/tstom/zip.gif"width="16"height="16"border="0"></a> <a href="http://home.fuse.net/tstom/0610081940.zip">0610081940.zip</a>

 

[AM]

Thanks for your answers.

You're great. I didn't knew the function MATCH!

AM