I am using Cell 2 and cell 3 of Column A
Column B and Column C
Column B is the Profit % and Column C is the Selling Price
cell 2 of column A is my search box where I want to enter Selling Price.
Presently, with the help of lookup formula,
When I entered the Cost Price in search box, the relevant cell which matches the value
in column C is highlited in Red Text. which is OK.
Now I want the excel formula with the help of which the value in Column B,
(corresponding to the highlighted text of Column C ) is
trapped in cell 3 of Column A.