Compare Similar Text to a Range of Cells

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
 
B

Bernie Deitrick

Either

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

woudl return 2....

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want formula to turn to value by itself 2
How to concatenate text into a formula? 5
Excel VBA 1
Searching alfanumaric cell contents and returning with a numaric v 21
forecasting and linking to a data range that is fluctuating 3
Making a structured reference absolute? 5
Enter number (data) into cells but want to show different data 3
Conditional Format Range of Cells 3

Top