LOOKUP - Complex lookup with 2 lookups in 1 cell

		Microsoft Office Forums > Microsoft Excel > Excel
LOOKUP - Complex lookup with 2 lookups in 1 cell

FAQ

Thread Tools

Display Modes

05-05-2016, 09:44 AM

sglandon

Windows 7 64bit LOOKUP - Complex lookup with 2 lookups in 1 cell

Office 2010 32bit

Novice

Join Date: May 2016

Posts: 4

Figured it out!!!

=VLOOKUP(LEFT(TRIM(A1),LEN(TRIM(A1))-3),Sheet2!$A$1:$B$9,2,0)&" - "&VLOOKUP(--RIGHT(LEFT(TRIM(A1),LEN(TRIM(A1))-1),1),Sheet2!$A$1:$B$9,2,0)

THANK YOU FOR ALL YOUR HELP!!!!!!!!!!!!!!!!!!!!!!!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup	Tony Singh	Excel	3	03-06-2015 11:03 AM
LOOKUP and IF FUNCTION	midgetmogalle	Excel	6	12-06-2013 09:35 AM
Lookup	angie.chang	Excel	1	07-27-2012 09:45 PM
Possible Lookup	Karen222	Excel	3	01-10-2012 05:41 AM
LookUp	aztiguen24	Excel	5	05-24-2011 03:57 AM

Other Forums: Access Forums

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