Hello,

I am trying to find a value within a group. I have a spreadsheet that I
have formatted and sorted so that it looks like:

Group Prod Name Amt.
a 123-33 chair 37.5
a 123-44 chair 38.01
a 123-45 chair 39.41
b 133-75 Table 33.25
b 133-68 Table 35.14
b 133-55 Table 30.75
b 133-53 Table 61.3
c 168-15 couch 60.28
c 169-74 couch 60.15
d 115-01 loveseat 75.01
d 115-02 loveseat 72.75
d 115-03 loveseat 73.05


Now as I am going through code I need to retrieve the Prod number. The only
thing I have to search with is the amount and group. For example:

I need to search first for group c and then search for 60.15 within the rows
starting with group c to return 169-74.

The file gets quite large and I was hoping a find method of some sort that
would let me find two values. I could do a loop to evaluate the group column
and then the amount column. Another way would be to find the first
occurrence of the group C and then the last row of group c and create a
range. Then I could loop through that range for the amount. Both methods
seem to be a long way to accomplish this.

Any ideas on a way to find the values in two columns?

Thanks,

Tony