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
  • 440 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by rproffitt
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.