Solved VBA Code/Formula to find left most value(s) and paste them descending

[Bean Machine]

Hi all. I am struggling to come up with a way to do this. I am assuming INDEX may be involved but not 100 percent sure how to pull it off. Basically, I want to check cell "C2" in worksheet "Driver" and based on what the value in cell "C2" is check range "B3:W3" in worksheet "Testing" and for a match (i.e., if "Dude 2" was the value in "C2") then store what column that match was in and check for cells with text in that column and return the left most most value to cell "D2" on worksheet "Driver" and onward for any cells that have values in them (i.e., "3,W,S,F"). Either formula or VBA code would be helpful to get this job done. See attached image for more context.

This is worksheet "Driver"

This is worksheet "Testing"

 

[GaP42]

Unsure as to where the text comes from. Are you expecting Dude 2 row in Drivers to have the value "3(W.S.F)" in cell D3, and Dude 6 row in Drivers to show the value "2(F,W) online" in corresponding cell (column D) where Dude 6 is listed, etc?
It would be helpful to attach a copy of your spreadsheet to work with.

 

[Gasman]

Give this a read.
I always have to reread any time I use Index and Match.

Index Match Formula

Combining INDEX and MATCH functions is a more powerful lookup formula than VLOOKUP. Learn how to use INDEX MATCH in this Excel tutorial.

corporatefinanceinstitute.com

 

[arnelgp]

see this demo.

 

[Bean Machine]

Give this a read.
I always have to reread any time I use Index and Match.

Index Match Formula

Combining INDEX and MATCH functions is a more powerful lookup formula than VLOOKUP. Learn how to use INDEX MATCH in this Excel tutorial.

corporatefinanceinstitute.com

This was helpful thank you!

 

[Bean Machine]

see this demo.

This was exactly what I was looking for. Thank you so much!