Excel Look for Value from one cell in another

gdavey · #1 08-26-2015, 06:53 AM

Hi

I am trying to find a number from one Column in some text which is in another Column.

So I am looking for the Year of construction (G) in the Note (B)

I have tried a few Vlookups but am getting no where

All help welcome

NoSparks · #2 08-26-2015, 01:56 PM

You haven't presented any data for us to know what you're actually working with.
I'd guess you need to look into the INSTR function.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM
Excel Cell Data in a Word doc	Jagobezzer	Word	1	09-30-2013 06:18 AM
How can I create hidden cell in Excel?	itsolexpert	Excel	2	05-15-2012 09:59 AM
How can I get excel to lock each value that is already in the cell l so I can add it	iasdfs	Excel	1	12-06-2011 12:52 PM
Splitting Excel cell into multiple	ruben23	Excel	1	07-23-2009 03:49 AM