On 11 Apr, 23:18, anon wrote:
OK got you.

=IF(AND(VLOOKUP(G1,C2:D11,1,FALSE)=G1,VLOOKUP(F2,A 2:B11,1,FALSE)=F2),VLOOKU*P(F2,A2:B11,2,FALSE),
0)

Thanks for replying anon. i tried your formula and its work fine but
when i drag this down it not working the way i want. the formula
should only bring value from the row where both other value matches.
it works fine in G2 cell but as i go down draging the formula its not
working. any help you can give on this. thanks