Keeping the source format when extracting data from multiple cells using Vlookup function

		Microsoft Office Forums > Microsoft Excel > Excel
Keeping the source format when extracting data from multiple cells using Vlookup function

11-14-2016, 03:17 PM

macropod

Windows 7 64bit Keeping the source format when extracting data from multiple cells using Vlookup function

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Another option would be to use small raised letters (typically inserted via Insert|Symbol) instead of numbers. See attached.

Attached Files

Test sheet.xlsm (57.3 KB, 26 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro for extracting data from multiple sheets if cell has text	plasma33	Excel Programming	0	11-10-2016 12:52 AM
Extracting data from a cell with multiple lines of text	MMT	Excel	9	02-12-2015 09:18 PM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1	bobznkazoo	Excel	2	03-27-2014 11:14 AM
Merging cells and keeping all the data/values	Holgate1967	Excel	1	11-29-2013 09:37 AM
Multiple VLOOKUP's checking multiple Cells	OTPM	Excel	11	05-23-2011 11:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:08 AM.