Member Avatar for kehar

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.

  • 2 Contributors
  • 1 Reply
  • 441 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by rproffitt
Member Avatar for rproffitt

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.