Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 : |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup problem - unable to get the vlookup property | Excel Programming | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming |