Microsoft Office Forums - View Single Post - LOOKUP - Complex lookup with 2 lookups in 1 cell

Thread: LOOKUP - Complex lookup with 2 lookups in 1 cell

View Single Post

Old

05-05-2016, 09:44 AM

sglandon

sglandon is offline

sglandon uses Windows 7 64bit

Windows 7 64bit sglandon uses Office 2010 32bit

sglandon uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: May 2016

Posts: 4

sglandon is on a distinguished road

Default

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!!!!!!!!!!!!!!!!!!!!!!!

Reply With Quote