Returning Fields after "x" on each row.

[QuickJeff]

I've tried a few different things. I would like to search horizontally by row for "x", then return the values from a couple of cells nest to the X.

Messed with HLOOKUP and V LOOKUP, yet I haven't figured out if it's appropriate for this.
All I need is someone to point me in the right direction : )

 

[T. Valko]

I imagine the fix is an IFERROR condition, but I could be wrong.

=INDEX($BY25:$XFD25,,MATCH("B",$BY25:$XFD25,0)+2))

That's one way (if you're using Excel 2007 or later).

=IFERROR(INDEX($BY25:$XFD25,MATCH("B",$BY25:$XFD25,0)+2),"")

 

[QuickJeff]

That's one way (if you're using Excel 2007 or later).

=IFERROR(INDEX($BY25:$XFD25,MATCH("B",$BY25:$XFD25,0)+2),"")

Very nice! Works like a charm. I'm getting better at reading the formulas. Makes perfect sense. Thank you so much for all of the help.

 

[T. Valko]

You're welcome! Thanks for the feedback!