Find and Extract Data

sandramac
sandramac used Ask the Experts™
on
Hello,

I have this forumla below that finds the first instance of OVC or BKN then taking the 3 digits after it.  How do I add another criteria.  Search in column A for the row that has "KQSA" then in that cell find the first BKN or OVC and extract the 3 digits right after that.

For example

Say in cell A25   it has KQSA 3305SM  9999 BKN055 A2999, it would extract the 055.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi

In B2

=INDEX($A$2:$A$50,MATCH("KQSA*",$A$2:$A$50,0))

In C2,

=MID(B2,LOOKUP(LEN(B2),SEARCH({"BKN","OVC"},B2))+3,3)

Kris

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial