Lookup Help

[Kylie]

I am trying to perfrom a lookup function. There are 3
columns and unfortunately the data is sorted in ascending
order for the 3rd column. There is another lookup formula
at work there. The lookup vector for my second formula is
not sorted. How can I get around this? I'll even use vb if
I have to.

Jan Feb
Red 5 89% Green 6 87%
Blue 3 91% Red 7 92%
Green 6 95% Blue 4 98%

I want to be able to identify the color and SUM the values
of the 2nd column for that color. My problem is that the
columns are already sorted based on the percentages in the
3rd column. Any help? Thanks

 

[Jason Morin]

I would suggest using VLOOKUP and specifying that you
require an exact match (use a 0 in the fourth argument).
That way, the data does not be sorted in any particular
order.

Or even try a SUMIF.

HTH
Jason
Atlanta, GA

 

[Mark Griffin]

You can use this (Assuming that your columns run A through
F)

=(SUM(B1+(INDEX(E1:E3,MATCH(A1,D13,0),1))))

This should return a value of 12 which is the sum of
values corresponding to the value "Red".