Hi

I have 2 ranges, for convenience i have copied in single sheet.
Range1 is a5:b2500 and Range2 is f5:h2500
now i want a function at c5
Like picking 2 words from a5 & b5 and
comparing all rows from f5:g2500, if they match then pick value in h cell
for example:
a5 = pink shiffon 20% woollen (2 words pink shiffon)
b5 = grand trunk textiles (2 words grand trunk)
match found at f200 & g200 with same words
then pick string at h200 "indent 2000 yards, in 4 sets......."
and place at c5
suppose you have 3 matches still pick the first match.
i need to copy the function from c5 thro c2500
i tried to use wmid() function but still not sure of my results
please help me.
if this not possible by function please give me macro, but I prefer function.
thanks in advance