excell help.PNG
Hello,
Can anyone pls help me to get the result in Cell K15 (of attached excel chart) as below:
K15= ( J15* a value( either "C5" if E15 & F15 matches with table B1: C8 or " F5" if E15 & F15 matches with table E1:F8)
I have attached the dummy table here. I hope i am able to make clear what i actually want.
If further info needed pls let me know.
Advance Thanks!
Bookmarks