Excel macro to find value with a condition

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Say, a code like C1180230 may occur more than once in column A, but its occurence with name "Recipe" in the previous cell is unique. I want the selection at "Recipe" cell at such a condition and proceed with further macro code those I already have. Is it possible?
Sharad

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
So are you only searching for this C1180230 (is this a concern number ? data look so familiar)
no, i would search for other such occurences. for now it appears to me that i need separate codes for different searches. this is one instance.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Sorry I was not clear earlier. What I wanted to know was how this number is picked to be searched etc. You need to provide some sample data and explain how you want

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.