Hi there,

I have a big list of data, across multiple columns. I need a formula
that search a specific value that is sitting in column X. If found, it
should return the value that is on the same row in column H.
The data can be found on the left side of column H (A-G) or on the
right side of column H (I-W).

Appreciate your help.