Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
getu32 getu32 is offline
external usenet poster
 
Posts: 2
Default Vlookup

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, B3:D6, 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 :