G
getu32
In VLookup / Hlookup function
I want to search from column C and then display the corresponding
value from Column A
Example.....
A B C
5 10 15
6 11 16
9 14 19
I select 16 (Column C) and my answer should be 6 (Column A)...
Now i want to write as follows =vlookup( E3, B36, 1, False/true) ,
but by default when i enter the value in the cell E3, it is searching
in Column A....But i want it to search in the Column C...
how to do it....
PS : it might sound quite stupid , i would just like to know that does
the symbol "$" mean in the array declaration $B$6:$D$10.
Thanks & Regards
Bodhisatya Sen
Please reply at : (e-mail address removed)
I want to search from column C and then display the corresponding
value from Column A
Example.....
A B C
5 10 15
6 11 16
9 14 19
I select 16 (Column C) and my answer should be 6 (Column A)...
Now i want to write as follows =vlookup( E3, B36, 1, False/true) ,
but by default when i enter the value in the cell E3, it is searching
in Column A....But i want it to search in the Column C...
how to do it....
PS : it might sound quite stupid , i would just like to know that does
the symbol "$" mean in the array declaration $B$6:$D$10.
Thanks & Regards
Bodhisatya Sen
Please reply at : (e-mail address removed)