Look up cell values with mixed number and letters

		Microsoft Office Forums > Microsoft Excel > Excel
Look up cell values with mixed number and letters

FAQ

Thread Tools

Display Modes

02-08-2013, 11:10 AM

Cardinal2

Windows 7 64bit Look up cell values with mixed number and letters

Office 2007

Novice

Join Date: Feb 2013

Posts: 10

Look up cell values with mixed number and letters

I would like to know if there is a excel function that can identify other cells that have mixed numbers and letters entries.
For example, Cell C1 has an entry- 19:44:B5. In the 400 cells in column d, only one cell has the identical mixed number and letter entry.
Is there a function that can look up and show the cell in column d that has the identical entry in C1 of 19:44:B5.

Any help would be appreciated
Matthew

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and replace with mixed formatting	pogonoforysci1	Word	2	09-26-2012 09:16 AM
change values based on cell	ubns	Excel	1	05-21-2012 06:28 PM
Automatic, Dependent Cell Values	flackend	Excel	2	08-26-2011 07:01 AM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 AM.