Query regarding any lookup function
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
|