I just want to know if any lookup value is repeating in range,which
function we should use at that time.
For ex

A B C
Name Value
a 2623
b 2561
c 12546
d 4563
a 452
c 223321
d 321

With above example i want to know how can we find each value for a in
lookup range A:A.
if is there any another nested function,please let me know

Regards
Ram

On May 1, 3:27*am, Ram wrote:
I just want to know if any lookup value is repeating in range,which
function we should use at that time.
For ex

A * * * * * * * * * * * * * * B * * * * * * * * * * * * * * * * C
Name * * * * * * * * * * *Value
a * * * * * * * * * * * * * * *2623
b * * * * * * * * * * * * * * 2561
c * * * * * * * * * * * * * * 12546
d * * * * * * * * * * * * * * 4563
a * * * * * * * * * * * * * * *452
c * * * * * * * * * * * * * * *223321
d * * * * * * * * * * * * * * *321

With above example i want to know how can we *find each value for a in
lookup range A:A.
if is there any another nested function,please let me know

Regards
Ram

If you want to sum look in the help index for SUMIF. To count look for
COUNTIF

On May 2, 1:14*am, Donald Guillett wrote:
On May 1, 3:27*am, Ram wrote:





I just want to know if any lookup value is repeating in range,which
function we should use at that time.
For ex

A * * * * * * * * * * * * * * B * * * * * * * * * * * * * * * * C
Name * * * * * * * * * * *Value
a * * * * * * * * * * * * * * *2623
b * * * * * * * * * * * * * * 2561
c * * * * * * * * * * * * * * 12546
d * * * * * * * * * * * * * * 4563
a * * * * * * * * * * * * * * *452
c * * * * * * * * * * * * * * *223321
d * * * * * * * * * * * * * * *321

With above example i want to know how can we *find each value for a in
lookup range A:A.
if is there any another nested function,please let me know

Regards
Ram

If you want to sum look in the help index for SUMIF. To count look for
COUNTIF- Hide quoted text -

- Show quoted text -

Hi,
I want to lookup the value for perticular name.For example if we use
vlookup for "a", as =vlookup(A3,A1:B7,2,0) then it will return 2623
for first occurence of "a" but i want to the value for second or third
occurence for a orb as 452 etc

Where do you want the results placed?

Some code by Don Guillet to return results to one cell..........C1

Option Explicit
Sub SAS_filternumbersfornames()
Dim mv As String
Dim mc As Long
Dim i As Long
Dim ms As String
mv = "a" 'value to lookup
mc = 1 'col A
For i = 2 To Cells(Rows.Count, mc).End(xlUp).Row
If Cells(i, mc) = mv Then ms = ms & Cells(i, mc + 1) & Chr(10)
Next i
MsgBox ms
Cells(1, mc + 2) = ms
End Sub


Gord Dibben MS Excel MVP

On Mon, 2 May 2011 08:09:58 -0700 (PDT), Ram wrote:

Hi,
I want to lookup the value for perticular name.For example if we use
vlookup for "a", as =vlookup(A3,A1:B7,2,0) then it will return 2623
for first occurence of "a" but i want to the value for second or third
occurence for a orb as 452 etc