Finding unsorted data

[chester12]

I have 2 sheets with a column of unsorted names.

example

I have the name Final Assault in cell AP1840 of the first sheet. In cell AS1840 I want to print the data for final assault from column F of the second sheet(called sheet2). The title Final Assault occurs in column E of sheet2.

I need to drag the formula down in the first sheet.There are some blank rows in the first sheet.Many of the titles in the first sheet
will not be in sheet 2.

The data in neither sheet can be sorted.

Thanks very much

Chester12

 

[chester12]

I think you have extraneous spaces around the entries. Either remove them or invoke:

=VLOOKUP("*"&AP1840&"*",Sheet2!E:F,2,0)

Does this fare better?

Thank you so much..works perfectly and I have learned a lot too.

 

[Aladin Akyurek]

Thank you so much..works perfectly and I have learned a lot too.

You are welcome. Thanks for providing feedback.