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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:18 AM.