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.

While I have used Excel since 1.0 days and spreadsheets since CP/M I have yet to trap a cell value. This may be why the lack of replies.
Also -> https://archive.is/N1SMQ