Compare Similar Text to a Range of Cells

  • Thread starter Thread starter yme
  • Start date Start date
Y

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
 
Either

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

woudl return 2....

HTH,
Bernie
MS Excel MVP
 
Back
Top