PDA

View Full Version : hlookup and vlookup



chungtinhlak
04-22-2009, 08:00 AM
Can we use this in the same statement. I have a matrix,


A B C D E F G
1 a a
2 g
3
4
5
6


I want to be able to find what the value of D4(using hlookup) and using vlookup.

Is there a way to do this?

thanks

xld
04-22-2009, 10:43 AM
Maybe

=INDEX(A1:G6,4,4)

chungtinhlak
04-22-2009, 11:12 AM
please see attachment

Ger
04-23-2009, 06:55 AM
I'm using the dutch version. So if you use the english version you have to replace "vergelijken" to "match"


Ger

xld
04-23-2009, 11:59 AM
I'm using the dutch version. So if you use the english version you have to replace "vergelijken" to "match"

Excel will handle that internationalisation automatically.