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
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
Maybe
=INDEX(A1:G6,4,4)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
please see attachment
I'm using the dutch version. So if you use the english version you have to replace "vergelijken" to "match"
Ger
Excel will handle that internationalisation automatically.Originally Posted by Ger
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber