HI
First time user, pls help.
In attached file I need to lookup a stock code(in cell E2) in Column A, and return a price(in cell G2) from Column C) based on quantity (in cell F2) as per quantity break in Column B for each of the stock codes in Column A.
Your assistance will be greatly appreciated.
Vernon
First time user, pls help.
In attached file I need to lookup a stock code(in cell E2) in Column A, and return a price(in cell G2) from Column C) based on quantity (in cell F2) as per quantity break in Column B for each of the stock codes in Column A.
Your assistance will be greatly appreciated.
Vernon