thanks
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Feb 26, 2010 at 2:15 PM, Christopher Luka
wrote:
> As a matter of advice, I'd use the offset/match combination even when you
> can use a standard vlookup. I
As a matter of advice, I'd use the offset/match combination even when you
can use a standard vlookup. In most cases, it's quite a bit faster than
VLOOKUP, *especially* when you have a large number of rows to process.
On Thu, Feb 25, 2010 at 8:45 PM, Manoj kumar wrote:
> Hi Anil,
>
> Please find
Hi Anil,
Please find the attached sample sheet for your reference
Regards,
Manoj Kumar
On Thu, Feb 25, 2010 at 8:54 AM, anil kumar wrote:
> Hello Everybody,
>
> My question is that suppose we have the below table
>
> Col A Col B Col C
> x ab 50
> z
hi anil
i think u need this formula for left vlookup
OFFSET(A1,MATCH(B4,B2:B5,0),0)
see the attached file for solution
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Feb 25, 2010 at 7:24 PM, anil kumar wrote
Hello Everybody,
My question is that suppose we have the below table
Col A Col B Col C
x ab 50
z mt 46
y ct 100
now i am searching value mt corrosponding value in Col A through the vlookup
function, but my conditio
