Q : How to pick value based on condition in macros vba : I want to pick a value based on a condition. The example data that I haved is like -> [my excel data][1]


  [1]: https://i.stack.imgur.com/uy93l.jpg

The condition is : 
I want to pick the value of PO NO. that always placed 2 column after text "PO NO."

How do I get that value?

