Dear Murli,
You can just give ref of column,,, for example if you want B column then
put (B:B).
=VLOOKUP($L24,$A$3:$D$6,COLUMN(B:B),0)
On Wed, Jul 10, 2013 at 4:43 PM, Muralidhar E wrote:
> Hi,
> Dear friends,
>
> Thank u
>
> With the same i want to know using column & columns
>
> *2.Thi
Hi,
Dear friends,
Thank u
With the same i want to know using column & columns
*2.This is using columns or column function*
=vlookup(lookup_value, Table array,*columns or column(array)*,range lookup).
I want to know how can we use both these functions.
1. Shall we can get the left side result
Dear Murli,
Find the same
Regards,
Prafull Jadhav.
On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E wrote:
> Dear friends,
>
> Good afternoon,
>
> I need a help and I want to know how to use vlookup function by using
> match and columns function. How it is works?
> Plz, share with me.
>
> *1.This
Dear,
Please find herewith VBA vlookup
one
Value look up in column 1 6
Value look up in column 2 vlookup2(F10, F11, tLookupDemo, 3) Result
Option Explicit
''
Dear Alan
Apply tis formula and your problem will be over.
VlOOKUP Function needs 4 parameters your 1st,2nd,& 4th parameters are
correct but in the 3rd parameter (Column no.) you supplied the column
address that is $E:$E. I have just changed it to column no. 2 which is
second column of your table w
Dear Alan
Apply tis formula and your problem will be over.
VlOOKUP Function needs 4 parameters your 1st,2nd,& 4th parameters are
correct but in the 3rd parameter (Column no.) you supplied the column
address that is $E:$E. I have just changed it to column no. 2 which is
second column of your table w
Thank you! I had problems when I just used an absolute column
number.
I did not realize that it was relative to the start of the table. In
the simple tutorials,
it is not clear whether it was supposed to be absolute or relative
(same in examples).
Hi Alan,
The third part of the formula, where you've put $E:$E has to be replaced by
either 1 or 2(since your table array is just D and E column).
Thanks,
Shreedar
On Sun, Oct 10, 2010 at 2:30 AM, Alan wrote:
> I am using Excel 2007 and having a strange problem with the VLOOKUP
> function.
