Thread
:
LOOKUP - Complex lookup with 2 lookups in 1 cell
View Single Post
05-05-2016, 09:44 AM
sglandon
Windows 7 64bit
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!!!!!!!!!!!!!!!!!!!!!!!
sglandon
View Public Profile
Find all posts by sglandon