Find and move base on value
 

So you always have one or the other?

=IF(COUNTIF(B1:C1,"net revenue interest*")0,
INDEX(B1:IV1,MATCH("net revenue interest*",B1:IV1,0)),
INDEX(B1:IV1,MATCH("account*",B1:IV1,0)))


LisaVH wrote:

I have a large report I bring over from another program (accounting software)
that I need to reformat in Excel for further data analysis. What I want to
do is create something that will find all cells that begin with "Net Revenue
Interest: XXXXXXX" or "Account: XXXXXXX" and move it to column A of the same
row (where the XXX are variable values). Is the possible??? Thanks.

--

Dave Peterson