Try to use this in cell B2
*=VLOOKUP($A2,INDIRECT(' B$1 '!$B$2:$R$302),16,FALSE)**
*
Copy it down
Pada 29/07/2013 18:22, Dhaval Shah menulis:
here with attach a file for reference
On Mon, Jul 29, 2013 at 4:49 PM, Dhaval Shah todhavals...@gmail.com
mailto:todhavals...@gmail.com wrote:
Thanks a lot for your solution. I got it..
Regards,
Vinu.
On Apr 24, 9:28 pm, Harsh Gharpure hsgharp...@gmail.com wrote:
For the data range you have specified, following is the solution:
A B C (formula)
25 0 -100 2 - =
Hello
Here is your solution.
Chandra Gupta
On Sat, Apr 24, 2010 at 3:03 AM, vinu vinu1sm...@gmail.com wrote:
Hello Frnds,
I have a data like this: columnA -Data column B- range column c-
Data in Range(Need formula for this), Please help me a formula to get
the answer in column C.
For the data range you have specified, following is the solution:
A B C (formula)
25 0 -1002-= countif(a1:a7,0) -
countif(a1:a7,100)
150101 -200 1 --= countif(a1:a7,100) -
countif(a1:a7,200)
250
Hello Frnds,
I have a data like this: columnA -Data column B- range column c-
Data in Range(Need formula for this), Please help me a formula to get
the answer in column C.
A B C
25 0 -100 2 ( Need a formula to count the col A data
which appears in B Col