A BIG THANKS FOR YOU BEARACADE... i cant believe its working!!! i am
celebrating now i swear.. i tempt to believe them when they say
"sometimes, you should look at things from different angle".. thank you
for your help :)

tim m, though the issue is solved, but i thank you for offering to
help.. here you go with the formula:

=IF(D3=A24,(B15/12)*B24,IF(D3=A25,(B15/12)*B25,IF(D3=A26,(B15/12)*B26,IF(D3=A27,(B15/12)*B27))))


--
blindhunter
------------------------------------------------------------------------
blindhunter's Profile: http://www.excelforum.com/member.php...o&userid=35600
View this thread: http://www.excelforum.com/showthread...hreadid=553733