Compare Similar Text to a Range of Cells

[yme]

I'm trying to a before and after worksheet that displays options as to what
the value could have been before without have to create a formula for each
line.

Example:
A1 Resource Forecast (Column Name = Deliverable)
B2 Resource Forecast and (Column Name = New Deliverable)
C2 Workplan
========================================
Required Result - The formula would fine A1 in cell B2

 

[Bernie Deitrick]

Either

=MATCH(A1 & "*",B:B,False)
or
=MATCH("*" & A1 & "*",B:B,FALSE)

woudl return 2....

HTH,
Bernie
MS Excel MVP