Find Text and display cell to left

[Austin0896]

Alright so I have a list of players on one sheet.

A Column Starting at 2 = Player Names
B Column Starting at 2 = Colleges

In another sheet I have a list of colleges and schedule strengths.

B Column Starting at 4 = Colleges
D Column Starting at 4 = Schedule Strengths

I want for in the first sheet, in a cell next to the player names and the colleges, I want a formula so that it matches the college name in A2 to one of the colleges in B4:B352, then for it to select the cell two to the right of the college on the second sheet, that number being the schedule strength.

I know I probably have to use VLookup but I'm lost.

[FDibbins]

Hi and welcome to the forum

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Austin0896]

There's no way to do this with a formula?

[Tony Valko]

Probably, but your description isn't real clear so seeing the data structure in a file will help us to help you.

A SMALL sample file with about 20 rows worth of data will be plenty.