I have 2 wkshts W1 & W2. From W1 I need to query a range (D1:Z1) in W2 to
find the column that contains the value that matches to W1!A1.

This should be so simple but like Thomas Edison I now know 1000 ways that
won't work.

Thanks,
Steve