Wildcard Search Range of Cells to Return That Cell Value

Hello all,
Kinda' stumped here. I would like to search a range of cells and return cell values based on a wild card text value. For example:

I would like to search on *lsf101server across A:G, and return any cells value that matches the wildcard search by row. I have attached an example of what I am trying to accomplish. (For some reason I can't "attach" a file, only and image, sorry)

Capture.PNG

Thanks in advance!

Bryce

The attachment button is not working here.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Try

=INDEX(A2:G2,MATCH("*lsf101server",A2:G2,0))

That did the trick!!!! Thank you very much Jonmo1 for your help!

You're welcome.