I have a LARGE set of data...

I parse it to a pivot.
red blue
Chair living room .1 .2
dining room .6 .3
bedroom .3 .4
sofa living room .9 .2
dining room .01 0
bedroom .2 .5

etc...
(4 colums, multiple rows)
I need to be able to:
Find what room a soffa is most likely to be in, and what that chance is, and
use that data in another worksheet where there will just be a list of
furniture, in room, with max chance.

I can seem to figure how to find the range of rows that have chairs (there
are not always the same amount of rooms in a list, sometime 2 someteims
20...) and use that found range in a vlookup or index to find the room.