Lookup Formula with multiple column

Hi There, I am trying to return data in a particular column but the lookup value could be in any of a number of columns and I am not sure the best way to pull this in. I have shown a snip with an exa...